Search found 37 matches
- Tue Feb 27, 2007 5:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to funnel sequential files?
- Replies: 2
- Views: 940
- Tue Feb 27, 2007 5:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to funnel sequential files?
- Replies: 2
- Views: 940
How to funnel sequential files?
I have the following scenario. Seq file A is transformed by B and some records are passed to the next transformer stage c while others are constrained and written to seq file E. Similarly some records and constrained by transformer c and written to seq file F. seq A | V transformer B ______ seq E | ...
- Sun Feb 18, 2007 7:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to write reject record
- Replies: 8
- Views: 2690
- Sun Feb 18, 2007 6:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to write reject record
- Replies: 8
- Views: 2690
OK I tried to put a null handling function in the transformer stage, yet still getting the same error. I used NullToValue(Lnk_in.Field1,'1999-01-01') in the transformer derivation. I also changed all the fields to non nullable, but still no avail. Could you explain why the DATE_FLD has been changed ...
- Sun Feb 18, 2007 5:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to write reject record
- Replies: 8
- Views: 2690
One of the switches in the Oracle stage lets you enable the reject link, look for it towards the bottom of the list. ... I found in the documentation that I have to change the Write Method to 'Upsert' to enable the reject link. when I did that I am getting the following error: Message: Oracle_Ent,0...
- Sun Feb 18, 2007 4:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to write reject record
- Replies: 8
- Views: 2690
- Sun Feb 18, 2007 4:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to write reject record
- Replies: 8
- Views: 2690
Not able to write reject record
I have the following scenario: I have a sequential file which consist of a date field in yyyy-mm-dd format. The file has 2 rows as followed. Row 2 is an invalid date. 2005-10-14 2007-25-12 I want to insert the data into an oracle table which has a date field. I passed the seq file straight through a...