DSXchange

1. To correctly answer your question, I am using the DB2 API Stage. 2. I would like to share some of our project details: a. Its a project done on 5.1 with around 500 jobs. Each of these jobs has a keyless look up and the information we have got is it is a working code on 5.1. b. We have to migrate ...

The transformer stage has been used for implementing the keyless look up logic. P.S. This logic has been implemented in 5.x version, not in 7.5. I have got this code for migration to 7.5.1 and it is failing there. I was just wondering how 5.x was handling it and how the job can be modified to work f...

Thanks all for your reply..... But this job design I have got is functional on DataStage 5.1. But when I am trying to run the same job on DataStage 7.5.1 server,it is aborting with the error: "NPRGMPCK5_UPGRADE_COPY..SIXJOLOF: No primary key column(s) defined for reference input. If the lookup ...

Hi, Is it possible to have a job design (running) in DataStage 5.x version where we have a source database stage and a look up database stage connected to a transformer without any keys defined for look up? Here some columns are being fetched from the source table and some others are being fetched f...

Hi All, We have some columns in our job with datatype as timestamp in target stage. We have given length 26 scale 6 with extended option checked with microseconds. 1. We have current timesatmp() function in the tranformer stage for assigning value to the target column. 2. Secondly we have tried pass...

Thanks for your reply, Nitin.

Whenever I use the IsNull function in Transformer job, I get the following compilation error, But when i Replace it with len =0 check, my job runs fine. What is the solution to this problem? Compilation Error: "Output from transformer compilation follows: ##I TFCN 000001 05:01:25(000) <main_pro...