DSXchange

You can also join on a dummy key . i.e. get the max seq # from database and then have a column generator for dummy column , join with link coming from main source , also 1 up number using database features like sequence or identity will kill the performance.

You can have join/lookup on warehouse to determine, if record already exists or to have two branches. For the insert record, generate 1 up number taking the max from warehouse.

You can build a shared container to abstract the logic of 1 up number and use that in the insert branch.

Thanks for replies We are trying run with 4 nodes and Jobs are getting aborted if we use "DB2" as partion. Error message is main_program: Fatal Error: Virtual dataset; output of "fltChangeData"; input to "db2udbTEST_DB2ENT": dataset does not have a partition method Than...

All, We have developed Parallel Jobs and we have used Hash Partion in the Jobs and for DB2 enterprise stage we have set "DB2" as partion method Jobs are running fine with single node and when we are testing the same with 4 node we have problems When we have changes the partion method as &q...

Any ideas on this highly appreciated. I think this will be vital to all of us to discuss on this . Please share your ideas.

Any comments from DataStage team are also welcome

Thanks
Pani

Thanks , It worked. Any idea on COMP-3 Conversion approach.

Hai We are trying to convert flat file from Mainframe to load DB2 dataware house hosted on Unix. In this process to convert COMP-3 fields we have comeout with following three approaches . 1) Using server Job and CFF Stage . But we are apprehensive of "Performance Issue" , Are we correct 2)...

We are trying to add a routine of type External which should refer to .O file generated from C program.

Job is not compiling when we try to compile and giving error message

Output from subprocess: ld: fatal: file /home/pd.o: unknown file type

Any help is highly appriciated . Please let us know