Need to convert pack decimal to read able format with dfsort

sandy mahajan · New User Joined: 31 Aug 2011 Posts: 4 Location: India

My requirement is that, my job would download the DB2 table into flat file and in next setp, I need to format that download file.
At column 1 have row count with define as interger (as db2 format). I need to format this to read able format.

When I am chekcing down load file it showing ROW COUNT in non readable format like pack value.

if db2 row count is 34567 then by out put would be 000034567 since in flat file I have allocated 9 bytes for this row count.
In out put file position start from 1-9 in download file the position for integer start from 1-4.
Please provide the solution.

sandy mahajan · New User Joined: 31 Aug 2011 Posts: 4 Location: India

I have tried

SORT COPY,
OUTREC FIELED=(1:01,4,TO=FS,LENGTH=09,M0)

enrico-sorichetti · Posted: Wed Aug 31, 2011 1:08 pm

topic edited to add the <code> tags,
learn how to use them in order to improve the readability of Your questions !

sandy mahajan · New User Joined: 31 Aug 2011 Posts: 4 Location: India

Thanks Enrico, I am very new to this forum, this is my very first post, I have put it.

sandy mahajan · New User Joined: 31 Aug 2011 Posts: 4 Location: India

Got it. I am able to fix this. This is very new for new, I rarely used DFSORT,

dbzTHEdinosauer · Posted: Wed Aug 31, 2011 2:30 pm

you know that you can CAST with your SQL in your download process,
negating the need for the DFSORT steps.

But, congratulations on your success with the sort control cards.