DSXchange

One datastage job is designed with 3 input oracle stages and one join stage and one output stage (sequential stage) o1------------ -> o2----------> Join (Left Outer)---------------->Output ^ o3--------------- In Join stage join type defined as left outer join and key column is C1 and all input stage...

I need to crerate header and trailer record in output file.

i.e HDR2009040210PM CST
Pavan,23,45,67,78
Kiran,34,56,78,9
Kim,45,67,89,08
TRL00003

Please let me know how we can implement above logic.

Hi,

I have to load the data in to one of DB2 table using DB2z load stage.
If any one use the DB2z stage ,Please provide the information how to set up the FTP and DATASET properties.

Thanks,
Raju

Hi ArndW,

If i will call the Unix command from command satge how can I capture the command stage result into User variable activity stage.


Thanks,
N.Raju

Hi ArndW,

If i will call the Unix command from command satge how can I capture the command stage result into User variable activity stage.


Thanks,
N.Raju

Hi,

I need to call the one UNIX command and I have to use that command result in nested condition stage.Is it possible to call the UNIX command from user variable activity stage.Please provide the syntax.


Thanks,
N.Raju.

Hi, I need to create one Trigger file for that I have designed the job like below. db2 stage----------->Transformer--------------->Target file. --------------->Trigger file(Zero byte) My requirement is whenever target file is created successfully than only creation of trigger file will be required. ...