MVSFORUMS.com

[anilkumar_mca]

Hi,

I am unloading data from a DB2 table to a flat file in my JCL. In my unload query I have the following calculation.

DAYS(date1) - DAYS(date2) + 1

while writing this value to the flat file, I am getting hexa decimal values in flat file. I need this value to be displayed in Numeric format. I've defined a nemeric variable with size 4 to receive this data in my easytrieve program.

Can anybody suggest me to convert this hexadecimal value to Numeric format in EASYTRIEVE or Is there any way I can get the numeric values directly from the unload query in to the flat file.

Thanks in advance.

[sriramla]

You can use DIGITS and/or CHAR function around this calculation to get the data in simple readable numeric format.

[kolusu]

anilkumar_mca,