SYNCSORT Addition of Zd fields

jk_mf53 · New User Joined: 28 Aug 2008 Posts: 3 Location: India

HI,
I need to add two fields containing ZD, the input file is as follows

00022390000000000{ 0000001735{
00022390000000000{ 0000001735{

the sort card i used is as follows

//SYSIN DD *
SORT FIELDS=(1,7,CH,A)
SUM FIELDS=(20,11,ZD)
OMIT COND=(20,11,ZD,LT,0)
/*

The output for this is as follows

00022390000000000{ 00000034700 <- i am getting the value of sign of ZD as zero Can anyone helpin making it correct??
[/quote]

Arun Raj · Posted: Wed Sep 17, 2008 8:07 pm

jk_mf53,

From the data you provided the input ZD field values are 17350 each which got summed up to give 34700.

Thanks,
Arun

dick scherrer · Posted: Thu Sep 18, 2008 3:00 am

Hello,

I believe what you are seeing is that the result of the SUM generated an "F" sign for the positive result rather than a "C" sign. This is usually not a problem as either works correctly when the number is used as a zoned-decimal value.

If you use values that have a negative sum (need to remove the OMIT for the test) you should get a "D" sign for the negative sum.

jk_mf53 · New User Joined: 28 Aug 2008 Posts: 3 Location: India

hi,

Thanks for the reply. The sign is coming when I try to give it as negative[ } ]. Is there any way to display the sign when it is positive? The requirement is such that sign [ { ] should be displayed when it is positive also.

Arun Raj · Posted: Thu Sep 18, 2008 10:55 am

Hello,

If you want to dislpay the signs, you can use the EDIT subparameter like this.

jk_mf53 · New User Joined: 28 Aug 2008 Posts: 3 Location: India

Thanks for the prompt replay. I wanted to be in this format 0000003470} and solved it by using OPTION NZDPRINT in the sort card.
Thanks & Regards,
J.k

dick scherrer · Posted: Thu Sep 18, 2008 8:35 pm

Hello,

Good to hear you have what you need

Just curious, but if the field is zoned-decimal, why does it make a difference if it is a "C" sign or an "F" sign?