Search found 263 matches

by snt_ds
Tue Apr 10, 2007 11:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading parameter file
Replies: 6
Views: 2699

Reading parameter file

Hi guru's,

Could you please suggest some methods to use parameter file in parallel jobs?In server jobs i was using DSSetParamFile before/after subroutine.Thanks.
by snt_ds
Tue Mar 20, 2007 1:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting job names from a sequencer.
Replies: 5
Views: 1485

I couldn't get in search results. I tried as you said. Please help me out.
by snt_ds
Mon Mar 19, 2007 6:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting job names from a sequencer.
Replies: 5
Views: 1485

Thanks, but I couldn't find the posting :oops: . I need list of the jobs designed in Job activities in the job sequence. Could you please help on that.

Thnx
by snt_ds
Mon Mar 19, 2007 5:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting job names from a sequencer.
Replies: 5
Views: 1485

Getting job names from a sequencer.

Hi, I am writing a routine. Job sequencer name I am passing as a parameter. I need to get list of job names that are calling in a particular sequencer. Can anybody please help me out, is there any option in DS to get the list of job names from the sequencer or else is there any other solution. Thank...
by snt_ds
Fri Feb 23, 2007 10:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File pattern warning in Sequential file
Replies: 9
Views: 2069

What triggers are on the Execute Command activity? The test command returns 1 if the test condition is not met. A pipeline such as that suggested by DSguru2B may be better, as the terminating command ( wc ) should always set its exit status to 0. You then need to test the command output (not its st...
by snt_ds
Fri Feb 16, 2007 11:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File pattern warning in Sequential file
Replies: 9
Views: 2069

Make sure in advance (in the job sequence) that there is at least one file that matches the pattern. For example, use an Execute Command activity to ls the directory with the file pattern, and test its exit status or output using the Trigger expression. You could, as an alternative, create a messag...
by snt_ds
Thu Feb 15, 2007 2:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File pattern warning in Sequential file
Replies: 9
Views: 2069

File pattern warning in Sequential file

We are using file pattern in sequential file for concat all files start with "aaam_classif*"and write into one output file. It is working fine if files are available, but if not found any single file that time we want job should be success. But we are getting one warning" Couldn't fin...
by snt_ds
Tue Feb 06, 2007 2:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remote Deployment
Replies: 1
Views: 693

Remote Deployment

Hi,

How does DSEE Remote deployment work? Does all the data as part of the paralell job move between the Server location and the remote location or it just the commands?

Also any other constrainst or imp points for the same?

NV
by snt_ds
Tue Jan 30, 2007 7:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CRC32 in PX
Replies: 15
Views: 6100

I would be more than happy to pay for it!!

Jokes apart, U have been of great help thru ur replies.
Thanks Ray.[/b]
by snt_ds
Tue Jan 30, 2007 7:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CRC32 in PX
Replies: 15
Views: 6100

Thanks.

What are the major differnces bewteen the 3 parallel job stages used for data comparision?
by snt_ds
Mon Jan 29, 2007 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking composite operator: Subprocess command
Replies: 8
Views: 4835

Ray,
thanks for the suggestion. However, I am not sure how to identify a composite operator. what is a composite operator?

I may be asking simple question but i dont know what it is? else i would i have diagnosed it.

thanks
by snt_ds
Mon Jan 29, 2007 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking composite operator: Subprocess command
Replies: 8
Views: 4835

Soure and target

Source: Decimal(15,3) Derivation: If IsNotNull(SUM_Daily_Read_Lnk.Cost) Then Right(Space(13) : Field(DecimalToString(SUM_Daily_Read_Lnk.Cost, 'fix_zero, suppress_zero'), '.', 1), 13) : '.' : Left(Field(DecimalToString(SUM_Daily_Read_Lnk.Cost, 'fix_zero'), '.', 2) : Str('0', 3), 3) Else Space(13) : ...
by snt_ds
Mon Jan 29, 2007 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking composite operator: Subprocess command
Replies: 8
Views: 4835

No Integer to Decimal Conversion

Hi,
There is no Integer to Decimal conversion in the job. I am converting Decimal values to string using DecimalToString function. So i believe it should be something else in the code.
by snt_ds
Mon Jan 29, 2007 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking composite operator: Subprocess command
Replies: 8
Views: 4835

Error when checking composite operator: Subprocess command

I am getting the following error. I dont think there are any errors as this job was running fine few days back. I am getting the following error. Error when checking composite operator: Subprocess command failed with exit status 256. It runs 1 process on 1 node. ##I TFOP 000094 16:01:23(000) <APT_Li...
by snt_ds
Thu Jan 25, 2007 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CDC Internal Functionality
Replies: 2
Views: 1316

CDC Internal Functionality

Hi, Can someone pls explain the internal algorithm or logic that Datastage CDC stage uses to compare the Before & After Dataset? Does it take the 2 sets of data in memory (per partition) and do a one to one row comparision..or some other way. Is there any architecture diagram or doc for this ava...