DSXchange

Makesure that @inrownum is generating correctly with multiple nodes .

Write a before job routine

cat header > out_file

after job routine

cat footer >> output_file .

Here header n footer are static in nature .

Take the export of the datastage job and within dsx file replace readonly parameter value from 0 to 1 or 1 to 0.

Is it the first time you are compiling your job in production environment ?

If yes , then you need to set APT_COMPILER_OPT and APT_LINKER_OPT to correct values .

I have not worked on DB2 much ..But if it is oracle enterprise stage then you can set some env variable to get the query in a directory .

Thanks

Yeah , we have faced similar type of problem with DB2 API stage .At that time , We were using 2 node file and records got duplicated .So , check if its the same in your case .

Thanks

You have lot of documentation and on top of it you have dsxchange

You can use find command to search for DSParams file

Check vincent blog in internet ..you can get very useful information

Also you acn use tr '\n' ' ' command

Within the sequential file or complex flat file , Use cobol copy books to read the data in the file ....Also could you please let us know what are the options that you are using dd command ??

"LIKE" and "BETWEEN" functions can be used in FILTER stage

Hi ,

Thanks for the quick response .I have found that in the below post

viewtopic.php?t=125699&highlight=impersonation+mode

I will check the UVCONFIG file and will get back.


Thanks

Hi Everyone ,

Can somebody help me in understanding "What is impersonation mode " in datastage ? Is it related to datastage ??

Note :Its not an interview question .

Thank you all .

Oracle enterprise stage also wont show the query unless job fails .Please correct me if i am wrong

Try cat filename | tr '\n' '|'