Search found 2886 matches

by qt_ky
Tue Apr 17, 2012 5:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading records to two interrelated tables
Replies: 9
Views: 4085

"Why did the chicken cross the mobius strip? To get to the same side."

I agree; challenge the DBA to provide a working example.
by qt_ky
Tue Apr 17, 2012 5:51 pm
Forum: General
Topic: DataStage Client Connect Issue
Replies: 2
Views: 1762

"Let's start at the beginning, a very good place to start..." Windows 7 will only support the client tier. If you want to install the 8.5 server tiers onto a Windows platform, then they need to go onto a supported OS like Windows Server 2003 or 2008. Check the system requirements: http://w...
by qt_ky
Tue Apr 17, 2012 5:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trouble with server shared containers
Replies: 3
Views: 1348

I think of the container as a place holder where the actual stages get plugged in at compile time (like an include file in programming), so I would not try passing a container name to the API function you mentioned. Instead go with a stage name from inside the container, just as it sounds like you h...
by qt_ky
Tue Apr 17, 2012 5:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: An insert, update, or delete statement failed to run
Replies: 15
Views: 21505

That's good. Problem resolved now?
by qt_ky
Tue Apr 17, 2012 5:39 pm
Forum: General
Topic: Error while starting WAS
Replies: 8
Views: 1889

Has anything changed recently on the server configuration, such as SSL security? I would suggest you contact Support with the error message.
by qt_ky
Tue Apr 17, 2012 5:32 pm
Forum: General
Topic: Waiting for multiple files
Replies: 13
Views: 6255

WTF stage... too funny! Create a file having the list of file names or file name prefixes. Create a Unix shell script that reads the file list, appends date info using the Unix date command and format options, and checks if each file exists. If any file does not exist, fail, otherwise pass. The scri...
by qt_ky
Tue Apr 17, 2012 5:21 pm
Forum: General
Topic: Equivalent of WeekdayFromDate in Job sequence
Replies: 7
Views: 3277

You can use the Oconv() BASIC function with date conversion codes like W for the day number of the week or WA for the name of the day of the week. See the DataStage BASIC Reference Guide for details.
by qt_ky
Tue Apr 17, 2012 5:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Db2 Z loader - Issue
Replies: 2
Views: 1291

I don't know the reason there, but the Connector stages are the preferred support way to go. The Connectivity Guide for DB2 will mention that in chapter 2.
by qt_ky
Tue Apr 17, 2012 5:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue during target load
Replies: 8
Views: 2097

Craig, looking forward to your getting "the power" to grant read to FAQ forum topics too...
by qt_ky
Mon Apr 16, 2012 10:32 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Notes
Replies: 5
Views: 2480

That kind of relates to the question I added into this topic... http://www.dsxchange.com/viewtopic.php?t=142146& If you run the Column Summary, Notes Detail report, you get 77 pages of junk thrown in with the notes. --- The IA HTTP API does not provide any options or XML having IA notes. --- If ...
by qt_ky
Mon Apr 16, 2012 10:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed Files Dictionary getting corrupted
Replies: 2
Views: 1168

Could be someone carelessly removed all D* files manually or by using a script.
by qt_ky
Mon Apr 16, 2012 10:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error on reading vb script generated csv file
Replies: 9
Views: 3299

Any chance there are extra characters hiding after CR/LF?
by qt_ky
Mon Apr 16, 2012 7:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: One mount point is getting hanged on datasatge server.
Replies: 2
Views: 1410

Suggest you work directly with your disk admin(s) and Unix admin(s)...
by qt_ky
Mon Apr 16, 2012 7:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert julian date to YYYYMMDD
Replies: 9
Views: 4030

DateFromJulianDay() is probably correct then. It expects input of type uint32.

What is the actual output date, not the format this time around... If you know the actual date, it will confirm if input is Julian.
by qt_ky
Mon Apr 16, 2012 7:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert julian date to YYYYMMDD
Replies: 9
Views: 4030

Yes, but what format is it in? Are you saying it's definitely Julian or do you know?

Just confirm the sample date you gave--what is the expected output date?

DateFromJulianDay() is probably correct then. It expects input of type uint32.