Search found 53125 matches

by ray.wurlod
Wed Mar 25, 2009 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setting column value as Parameter
Replies: 4
Views: 1909

The first job will need to be a server job or use the BASIC Transformer stage if a parallel job.
by ray.wurlod
Wed Mar 25, 2009 11:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Aggregator performance
Replies: 9
Views: 2618

Encase your design in Code tags so we can understand it better.
by ray.wurlod
Wed Mar 25, 2009 8:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datetime on Sequential File
Replies: 4
Views: 1581

Conversion functions StringToTimestamp(), TimestampToDate() and DateToString() should do it.
by ray.wurlod
Wed Mar 25, 2009 8:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: List of SYS tables
Replies: 6
Views: 1643

mandyli wrote:But still i am not able to see your full information.
That, at least, is easily remedied.
by ray.wurlod
Wed Mar 25, 2009 8:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Packed Decimal and Signed Integer
Replies: 2
Views: 1348

Thank you for posting these.

You can eliminate most of the Case constructs where the values are contiguous. For example the last one could be replaced by

Code: Select all

vLastByteHex = Char(208 + vLastByte)
by ray.wurlod
Wed Mar 25, 2009 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: List of SYS tables
Replies: 6
Views: 1643

Here is the complete list.
SYS.HELP
SYS.MESSAGE

The first is a multi-level file (for help on different subject areas). The second is a simple static hashed file.

UniVerse manuals, particularly UCI, are the best source to decode error messages.
by ray.wurlod
Wed Mar 25, 2009 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy of Datasets in different environment
Replies: 3
Views: 1191

It's not possible to move a Data Set from one machine to another. All the pathnames in the control file will be wrong, and there's no mechanism for repairing them.
by ray.wurlod
Wed Mar 25, 2009 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare Stage output
Replies: 1
Views: 935

If there's anything in them the Peek output in the log will show it. In a job you can use Promote Subrecord stage.
by ray.wurlod
Wed Mar 25, 2009 3:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to wait for and process multiple and changing name file
Replies: 7
Views: 5152

You can use an Execute Command activity to execute an ls -1 command and pipe its results through sort. Then use a User Variables activity to change the field marks in the command output to commas, and the result becomes your "list of things" list (comma delimited) in a Start Loop activity....
by ray.wurlod
Wed Mar 25, 2009 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed to Connect to DataStage server <Project Name>
Replies: 3
Views: 1744

vadivel_2k wrote:Hi Ray,

Is it possible that system itself will remove all the essential files/directory (DS_* & RT_*) under any circumstances.
No.
by ray.wurlod
Wed Mar 25, 2009 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting rows between two dates
Replies: 11
Views: 3235

OK, you're getting the two dates from Oracle and you want to generate one row for each date in the range? Create one job to read from Oracle and the other to generate the rows, which receives the two dates as parameters. In the first job invoke UtilityRunJob() to run the second job and pass it the t...
by ray.wurlod
Wed Mar 25, 2009 6:26 am
Forum: General
Topic: Combine Records
Replies: 6
Views: 1962

You were probably typing that while I was typing my solution.
by ray.wurlod
Wed Mar 25, 2009 6:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read COBOL file definition
Replies: 1
Views: 1071

Silly requirement really. What you need to do is to IMPORT the COBOL file definition. What do you plan to do with it once you've read it? And why is it urgent? We don't do "urgent". DSXchange is an all-volunteer site whose members post as and when they can, and usually only if they have so...
by ray.wurlod
Wed Mar 25, 2009 6:18 am
Forum: General
Topic: Combine Records
Replies: 6
Views: 1962

If the inport is sorted by Record_ID, then you can assemble the output record putting the correct value in the correct field via If..Then..Else statements in a Transformer stage (use stage variables initialized to null, and name the stage variable in the Else part). Then run the output through a Rem...
by ray.wurlod
Wed Mar 25, 2009 4:31 am
Forum: General
Topic: Login into datastage
Replies: 6
Views: 1646

What operating system are you using?