Search found 48 matches
- Sun Nov 04, 2007 11:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting Null into Not Null Using Modify Stage
- Replies: 5
- Views: 3621
Converting Null into Not Null Using Modify Stage
I want to convert Null to Not Null of a column with data Type as Date. I am using Reprt_Date : string = NullToValue (Reprt_Date,"Null") in the Specification of Modify stage. But I am getting error as "main_program: Error parsing modify adapter: Error in binding: Unknown conversion: Nu...
- Tue Oct 30, 2007 12:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Full Outer Join in Join Stage
- Replies: 3
- Views: 2612
Full Outer Join in Join Stage
I have tried with the option that is given in the Transformer Stage but the data is not coming through the Transformer.
- Mon Oct 29, 2007 7:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Full Outer Join in Join Stage
- Replies: 3
- Views: 2612
Full Outer Join in Join Stage
Hello, I have problem in using the FULL OUTER JOIN in JOIN Stage. There are two inputs and i am using a Join Stage and I need all the records of the Inputs so I am using FULL OUTER JOIN Option. If we use Full OUTER JOIN for the key attribute there will be extra columns for that key(i am Using FOUR K...