Order by epcidic

[dspxlearn]

Hi,


We are running parallel jobs taking our source from DB2...where i have a DB2 query in which we have 5 orderby ascending columns.In which first two are coming with 'Char' as data type, second column is of 'Date' data type and the other two(4th and 5th) are of data type 'Integer'.Our target is of variable lenghts columns...We are converting first three columns(Char data type for 1st, 2nd and Date data type for the 3rd) to varchar for the target, and for the integer Data type we are keeping the same....In the target sequential file we are sorting all the columns in ascending order and for the first three columns we are giving "Sort by Epcidic" as True...

In the target the first three columns are done orderded by ascending but not rest of the two.....


Why is it happening this way...and what should we add on the same for the proper order....