I have problems with unloading data in hex format

prem_ibm · New User Joined: 15 Sep 2007 Posts: 31 Location: Chennai

Hi All

i have used sam e Unload utility to unload the db2 data in to the flat file,job went fine but there is a some problem in out put some data are coming in HEX format.

So can u any body tell me what are the changes need to be done in jcl to get corec output in data set.

Thanks
Prem

Craq Giegerich · Posted: Thu May 22, 2008 6:14 pm

Try using the DB2 UNLOAD utility.

vebs · New User Joined: 27 Oct 2007 Posts: 19 Location: UK

Use casting.. like CHAR(your column name)

Phrzby Phil · Posted: Fri May 23, 2008 1:53 am

So, since I'm not a good guesser - which field types are causing the problem?

stodolas · Posted: Fri May 23, 2008 1:54 am

HEX or packed?