MVSFORUMS.com

philipd · Beginner Joined: 15 Feb 2005 Posts: 1 Topics: 1

Hi

i am unloading a DB2 table into a flat file whose first column is of INTEGER format.

Could anybody please provide the SORT card to convert this INTEGER field i,e comp 9(9) field into PIC 9 format.

Thanks
-philip

sathishgay · Posted: Tue Feb 15, 2005 6:14 am Post subject:

hi friend
it was alread discussed so plz check ,

it was explained by kolusu

Check this link for a detailed explanation of the DFSORT'S OUTREC parm

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA00/3.14?DT=20031124143823

check this link for detailed explanation on DFSORT'S Data formats.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA00/C.1?DT=20031124143823

Hope this helps...

Cheers
_________________
OK

bauer · Posted: Tue Feb 15, 2005 6:48 am Post subject:

Hi,

other solution is:

Create a view, which provides the integer column as char.

Unload this view.

regards,
bauer