Search found 7 matches
- Thu Dec 28, 2006 9:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Look Up Without Keys
- Replies: 12
- Views: 6777
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 ...
- Thu Dec 28, 2006 9:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Look Up Without Keys
- Replies: 12
- Views: 6777
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...
- Thu Dec 28, 2006 1:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Look Up Without Keys
- Replies: 12
- Views: 6777
- Tue Dec 26, 2006 8:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Look Up Without Keys
- Replies: 12
- Views: 6777
Look Up Without Keys
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...
- Sat Jan 21, 2006 7:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Default Timestamp Format in Datastage EE
- Replies: 3
- Views: 12472
Default Timestamp Format in Datastage EE
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...
- Sat Dec 10, 2005 8:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error with IsNull function
- Replies: 9
- Views: 6266
- Sat Dec 10, 2005 5:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error with IsNull function
- Replies: 9
- Views: 6266
Error with IsNull function
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...