Posted: Wed Feb 02, 2011 12:34 pm Post subject: Sorting a FLAT file
hi,
I've unloaded CHAR(10) data from a DB2 table to a flat file, so the file is created with LRECL=10. The db2 table always contails numbers in this column. My unload file looks like,
11111111
33333333
22222222
9999
Remember the last record (9999) is the smallest number among all the input data
I tried sorting the file with all the data types(CH,ZD,BI,PD) in the following sort card, but nothing seemed working.
SORT FIELDS=(1,10,CH,A)
My output file should look like
9999
11111111
22222222
33333333
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum