Difference between BI,TO=ZD and EDIT=(TTTTTTTTT) options

Ramanan-R · Posted: Tue Feb 23, 2010 10:32 am

Hi All

,

A file has a binary field (4 bytes) holding 9 digit numeric value. The requirement is to convert that binary field from COMP/Binary format to ZD/Display format.

I tried below codes in Syncsort, but both are providing different output values but EDIT option gives the required output. Can anyone explain their difference?

dick scherrer · Posted: Tue Feb 23, 2010 10:43 am

Hello,

In a zoned-decimal field, the sign is the high-order nibble of the low-order byte. The letter H is the value for a positive 8. For a negative 8, the value would be Q.

Signed Positive values have a "C" sign (H is x'C8') and Signed Negative values have a "D" sign (Q is x'D8'). There is an "implied positive that has an "F" sign, so the number is visable (8 is x'F8').

Ramanan-R · Posted: Tue Feb 23, 2010 11:03 am

Hi Dick,

Thanks for the information.

Can you pls explain how H is mapped to +8 and Q mapped to -8

Thanks again...

Regards,
Ramanan R

dick scherrer · Posted: Tue Feb 23, 2010 11:09 am

Hello,

Please re-read the previous reply. That is the explanation. . .

Suggest you edit a member and key in A-I and J-R. Then turn HEX ON. You will see positive and negative 1 thru 9. I'll leave it to you to discover plus and minus zero.

Ramanan-R · Posted: Tue Feb 23, 2010 11:27 am

Hi Dick,

I tried as you advised and got the below results...

dick scherrer · Posted: Tue Feb 23, 2010 8:40 pm

You're welcome

Now, i suggest editing that file/member and inserting 2 more values in hex - x'C0' and x'D0'. Then you will have a "complete" set of signed zoned-decimal values from zero thru 9.

Ramanan-R · Posted: Wed Feb 24, 2010 12:20 pm

Hi Dick...

Thanks again... Below is the output...

skkp2006 · Posted: Wed Feb 24, 2010 1:41 pm

maybe this can add a little help....

The following is a table identifying the zoned decimal hex characters.

dick scherrer · Posted: Wed Feb 24, 2010 8:25 pm

Hello,