IBM Mainframe Forum

Hello Forum,

I have unloaded data from Db2 table to seq file.Below is the Query to unload

Below highlighted is my data[starts from the 195th position to 198] which I am showing in HEX[Its the count I got from COUNT function while unloading the Db2 table]. I am trying to convert it to ZD using the 237:195,4,PD,EDIT=(IIIIIIIT) in my OUTREC but I am getting all zeros.
000003002000000000
00000851C000080000
------------------

Could anybody tell where I would be going wrong?

Thanks,
Shankar.

It is not a packed-decimal field. Use BI if it is a binary field.

BillyBoyo wrote:It is not a packed-decimal field. Use BI if it is a binary field.

Thanks a Lot BillyBoyo..I changed from PD to BI, It worked as expected.
Have a good day.