Search found 6 matches

by Raj6778
Tue Nov 20, 2007 9:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting Parameter Value into Oracle Stage forHeaderTrailer
Replies: 6
Views: 2917

In your code you need to assign the result of DSAttachJob to your Handle variable. Handle = DSAttachJob("Header_File", DSJ.ERRWARNING) RealName = DSGetJobInfo(Handle, DS ...[/quote] Thanks Ray, I tried your code, only all the commands are being showed in red in the basic transformer, only...
by Raj6778
Tue Nov 20, 2007 9:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting Parameter Value into Oracle Stage forHeaderTrailer
Replies: 6
Views: 2917

In your code you need to assign the result of DSAttachJob to your Handle variable. Handle = DSAttachJob("Header_File", DSJ.ERRWARNING) RealName = DSGetJobInfo(Handle, DS ...[/quote] Thanks Ray, I tried your code, only all the commands are being showed in red in the basic transformer, only...
by Raj6778
Tue Nov 20, 2007 9:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting Parameter Value into Oracle Stage forHeaderTrailer
Replies: 6
Views: 2917

In your code you need to assign the result of DSAttachJob to your Handle variable. Handle = DSAttachJob("Header_File", DSJ.ERRWARNING) RealName = DSGetJobInfo(Handle, DS ...[/quote] Thanks Ray, I tried your code, only all the commands are being showed in red in the basic transformer, only...
by Raj6778
Mon Nov 19, 2007 7:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting Parameter Value into Oracle Stage forHeaderTrailer
Replies: 6
Views: 2917

Inserting Parameter Value into Oracle Stage forHeaderTrailer

I have a 4 jobs, 3 jobs which take a parameter from 4th job contrl, which is used in sql in each header, data and trialer job for each distinct value of parameter I am trying to use utilityjobrun in basic transformer stage, I get fatal error mesage that the parameter not found in job, UtilityRunJob(...
by Raj6778
Tue Nov 13, 2007 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to install Datastage Command Stage Plugin
Replies: 4
Views: 2964

How to install Datastage Command Stage Plugin

How to Install and get started with Command Stage Plugin. Please share your experience with the command stage, thanks in advance
by Raj6778
Mon Nov 12, 2007 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Write One row of dyanamic data from the query result
Replies: 2
Views: 1239

How to Write One row of dyanamic data from the query result

I am trying to write 1 row of query data runtime as a headerline for sequential file, just one row, any suggestions

thx in advance