SYNCSORT (OUTREC) HELP Required!!

Vinodpujari · New User Joined: 22 Jul 2007 Posts: 6 Location: India

Hi all,

I have a requirement where i need to multiply a COMP field with a factor 0.97 for certain conditions.

I am using below sort card. it is giving syntax error.

SORT FIELDS=COPY
OUTREC FIELDS=(1:1,24,25,6,ZD,MUL,+0.97,TO=ZD,LENGTH=6,
31:31,185)

How ever if i use any factor with out decimal point (say MUL,10) then it is working.

Please help me out, as I am trying for an emergency move into production.

Thanks,
Vinod.

dick scherrer · Posted: Thu Dec 04, 2008 6:54 am

Hello,

Is the number COMP or Zoned-Decimal (ZD)?

What error is presented? Post the error message(s) including the message id(s).

Vinodpujari · New User Joined: 22 Jul 2007 Posts: 6 Location: India

Thanks for the reply,

i got the below error
----------------------------------------------------------------

Arun Raj · Posted: Thu Dec 04, 2008 7:33 am

Vinodpujari,

AFAIK, you can mention only an integer value for any arithmetic operation. Try changing the cards to something like this.

dick scherrer · Posted: Thu Dec 04, 2008 7:37 am

Hello,

You are using Syncsort rather than DFSORT.

PIC S9(4)V99 is not COMP.

Try removing the () around the .97.

What release of Syncsort are you using? If you are not sure, it is shown at the top of the informational output from a sort execution.

Vinodpujari · New User Joined: 22 Jul 2007 Posts: 6 Location: India

Hello all,

Thanks for all the replies,

I got the solution to this problem. As I stated earlier that i cannot give decimal point values such as .97, i modified my sort step into 2 parts. In the first sort, i divide the field by 100 and in the second step i multiplied the field by 97 which effectively makes it to .97.

STEP1:
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,24,25,6,ZD,DIV,100,TO=ZD,LENGTH=6,
31:31,185)

SYSIN :
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,24,25,6,ZD,MUL,+97,TO=ZD,LENGTH=6,
31:31,185)

This worked fine.

Vinodpujari · New User Joined: 22 Jul 2007 Posts: 6 Location: India

Yup, S9(4)V99 is not Comp. It was a typo from me, sorry for that...

Anyways this problem got solved....

dick scherrer · Posted: Thu Dec 04, 2008 10:28 am

Hello,

Good to hear it is working - thank you for letting us know.

If you want to save a step (or if the volume is huge) you might want to try the code Arun suggested above. It should accomplish the multiply and the divide in the same step.

Vinodpujari · New User Joined: 22 Jul 2007 Posts: 6 Location: India

Yes, I haven't checked the code what Arun suggested. It makes more sense, i will try that later with a small change like first Div by 100 and then multiply by 97.

Thank you...

Arun Raj · Posted: Thu Dec 04, 2008 11:10 am