Search found 4 matches

by Shailendra_dstage
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.
by Shailendra_dstage
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'
by Shailendra_dstage
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.....
by Shailendra_dstage
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...