MVSFORUMS.com

[Rahull]

Hi,

I need to use only syncsort to acheive the solution for the given below problem in a single step.

Problem: My input file is of length 3123. I need to create 2 output file.

Requirement: Input file have 16 digit Policy number, 10 digit date & Flag(which can have 'F' or 'A') and the condition is if the duplicate Policy comes with different date then I have to keep the Oldest date record.

Output 1) Only one field. i.e Unique Policy Number (Policy only which comes with Flag 'F")

Output 2) all records...Sorted on the basis of policy and date fields... Without any duplicate...(i.e. it might happen that more than 1 record comes with same policy with everything same except the date , then in that case i have to keep the oldest date)

I tried out with following control card but its not giving the desire result:

INREC FIELDS=(1,80)
SORT FIELDS=(35,16,CH,A,63,10,CH,A,)
SUM FIELDS=NONE
OUTFIL FILES=01,INCLUDE=(80,1,CH,EQ,C'F'),OUTREC=(35,16)
OUTFIL FILES=02,INCLUDE=(80,1,CH,NE,C' '),OUTREC=(1,80)

[kolusu]

Rahul,

Can you post a sample Input and desired output.

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

[Rahull]

Hi,

First of all, there is a correction, the input file is of 3123 and I mentioned 80 in the control card.

Sample Input:
+----4----+----5----+----6----+----7----+----8 ----124----
5106A 777802 A451010001222003-01-10 F
5106A 777802 A451010001222003-01-11 F
5106A 888786 A451010001182003-01-10 A
5106A 888786 A451010001182003-01-19 A

Output 1)
----+----1----+-
5106A 777802

Output 2)
+----4----+----5----+----6----+----7----+----8 ----124----
5106A 777802 A451010001222003-01-10 F
5106A 888786 A451010001182003-01-10 A

[Rahull]

sorry there was an alignment problem....
Hi,

First of all, there is a correction, the input file is of 3123 and I mentioned 80 in the control card.

Sample Input:
Column (starting from 35)

[sasubashri]

Rahul,
Hope this helps.

Temp1 will have the output1 and temp2 the output2 as shown in your post.

[sasubashri]

Rahull,
I assumed the position of the flag to be on 81. Please change that to 122.

Thanks,
Subashri.
_________________
Thanks,
Subashri.

[kolusu]

Rahul,

If I understand correctly your Policy number starts from pos 35 for 16 bytes and your date is in position 63 for 10 bytes and your flag indicator is in pos 124? If this assumption correct, then the following job will give you the desired results.

[Rahull]

My Client doesn't allowing me to usee SYNCTOOL ...

We can use only SORT or SYNCSORT.

[Rahull]

Kolusu Is it possible using SYNCSORT ????

[kolusu]

Rahul,

Synctool is a part of syncsort but it is an unsupported feature. You can split the job into 2 steps as follows.

[Rahull]

Thanks but I knew doing that in 2 steps. The challenge before me to do in one step..
See below is the new control card I am using..

INREC FIELDS=(1,3123)
SORT FIELDS=(35,16,CH,A,124,1,CH,A)
SUM FIELDS=NONE
OUTFIL FILES=01,INCLUDE=(124,1,CH,EQ,C'F'),OUTREC=(35,16)
OUTFIL FILES=02,INCLUDE=(124,1,CH,NE,C' '),OUTREC=(1,3123)

First output is as per my requirement.
But second output keep the policy which comes first in order. I want the policy with oldest date. How do i use the data feild in above card.
Any suggestion??

[kolusu]

Rahul,

Try this

[Rahull]

Hi,

I tried with the option that u mentioned.

Sorry but could not get unique result for both the output file.

I am still getting the same policy record 2 times with everything same except the date for output 2.

and for output 1 ..same policy number 2 times ( Becuase in input file everything is same except the date..)

[kolusu]

Rahul,

I can't think of a way to achieve it in a single step. sorry

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