Search found 3 matches

by ece_balaji
Thu Jul 30, 2009 11:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: User inserted sort does not fulfill the sort requirements
Replies: 3
Views: 7686

This is the first time i came across this warning and its a join stage. The crazy thing here is, i did a hash patitioning and sorted on 2 keys and those 2 keys where varchar fields. "When i made the partitioning keys as case sensitive the warning disappeared" I made the partitioning keys a...
by ece_balaji
Wed Jul 15, 2009 5:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing fixed width file with COBOL datatypes
Replies: 3
Views: 1428

I tried writing to the CFF stage and it works. I have created the file after all trial and errors, learning the relation between oracle datatype and cobol datatype :). But i am not sure whether the compressed variables would be read with the same values in MF. I will post again when the file is test...
by ece_balaji
Thu Jul 09, 2009 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing fixed width file with COBOL datatypes
Replies: 3
Views: 1428

Writing fixed width file with COBOL datatypes

Hi, I have a requirement to create a fixed width file with COBOL datatypes (PIC X(2), PIC S9(7)v99, PIC S9(05) COMP-3, PIC 9(10) COMP-3) whereas my source is oracle. I understand we could use a sequential file if all the decimal fields are one of these (packed or zoned or overpunch) But here in my t...