MVSFORUMS.com

bprasanna

Hi all,

Is there any way in sort to get the remainder of a number?

I am having a filed in my flat file. I need to get the final value with this below function.

Output = (xxx - 1) mod 12

where xxx is the number from my input file.

Let's think that my xxx is having the value of 353.Then

Output = (353-1) mod 12
= Remainder of (352/12)
= 4

Please note my shop doesn't have DFSORT.It is having only the SYNCSORT.

Thanks
Murali

Frank Yaeger · Posted: Fri Jun 11, 2004 9:03 am Post subject:

I know you said you have Syncsort, not DFSORT, but for the record, here's an example of how you could do this with DFSORT:

kolusu · Posted: Fri Jun 11, 2004 9:12 am Post subject:

Try this,

bprasanna · Posted: Mon Jun 14, 2004 7:24 am Post subject:

Hi,
Thanks for u r reply.I got another doubt here.Can we do it only with
OUTREC statement(as same as Frank's reply) ?Because I need to list out some other details from the input and I need to perfome some other calculations on the same field.

kolusu · Posted: Mon Jun 14, 2004 7:53 am Post subject:

bprasanna,

Post your complete requirement and may be we can suggest something. Also post the LRECL, POSITION of the computing field and RECFM of the input of the dataset. It would be great if you can post a sample input and desired output

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

bprasanna · Posted: Tue Jun 15, 2004 8:57 am Post subject:

Hi Kolusu,
Thanks again for u r reply.

Here is my requirement.

We are having FB file of length 714.The data in it is like below.

$ 100136940201 090 *
51FFFFFFFFFFFF04111FFF 00500
B51001369402010055509013C1C

Here I am having the hex value(which is in red) 01035C010C.
Now I have to peform the following calculations on this value.

Calculation 1: (01035-1) Mod 12 + 1.

So I will get the value as 3.

I tried with u r previous example.That is working fine for all conditions except for the below.

If i am having the hex value as 00780c001c,
then
= (780-1) mod 12 + 1
=11 + 1
=12

Where I am getting the problem is once we divide the input value with 12 ,it is rounding the value to 65,but we need 64 only over there.

then we will get the correct value.

Ie..064 779----------->from the in rec statement
779-(64*12)---------> 11 +1 =12--------->from out rec statement.

I hope I am able to explain my problem.

kolusu · Posted: Tue Jun 15, 2004 10:22 am Post subject:

bprasanna,

Let me get this clear.

You have a number ex: 353 , 780...

1. You need to subtract 1 from that number which makes them as 352, 779 ...

2. Divide this number by 12 to get the remainder which is 4 and 11 respectively.

3. Now add 1 to the remainder which makes them 5 and 12 respectively

Is that right ?

If that is true then the following JCL will give you the results.

bprasanna · Posted: Wed Jun 23, 2004 2:38 am Post subject:

Thank you very much Kolusu!!!It worked fine!

Since as I am out of station,Today I checked it and it worked fine.

Thanks again..