Search found 4 matches
- Tue Feb 22, 2011 12:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capture reject record from DB2 stage
- Replies: 2
- Views: 1880
Capture reject record from DB2 stage
i want to capture reject records in seq file from DB2 stage having write method/mode as write/append.
- Fri Feb 18, 2011 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: convert 'mm/dd/yyyy' to 'yyyy-mm-dd'
- Replies: 4
- Views: 5156
convert 'mm/dd/yyyy' to 'yyyy-mm-dd'
my input is '1/19/2011' i am reading as varchar. I need to convert it to '2010-01-19'
- Wed Dec 22, 2010 8:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to read sequential file in multinode option
- Replies: 2
- Views: 4429
Are you certain it is fixed-length? Doesn't sound like one if you can't divide the total byte size by the record count and get an even number. Thanks craig for giving me the hint..i divided the total byte size with no. of records in the file and found that i was missing 2 bytes to add in metadata.....
- Wed Dec 22, 2010 8:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to read sequential file in multinode option
- Replies: 2
- Views: 4429
Not able to read sequential file in multinode option
Hi, I am not able to read sequential file (fixed with). it is giving following error- Cannot use multinode: The file length (181286) is not a multiple of the record length (364). where as if i choose "Read from multiple node" as NO..i can view the data from the file form seq file stage but...