Facing problem while converting PD to ZD



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Facing problem while converting PD to ZD

Postby shankar_dh » Tue Feb 11, 2014 7:55 pm

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.
shankar_dh
 
Posts: 41
Joined: Fri Mar 22, 2013 1:00 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Facing problem while converting PD to ZD

 

Re: Facing problem while converting PD to ZD

Postby BillyBoyo » Tue Feb 11, 2014 8:06 pm

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

These users thanked the author BillyBoyo for the post:
shankar_dh (Tue Feb 11, 2014 8:11 pm)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Facing problem while converting PD to ZD

Postby shankar_dh » Tue Feb 11, 2014 8:12 pm

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.
shankar_dh
 
Posts: 41
Joined: Fri Mar 22, 2013 1:00 pm
Has thanked: 1 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post