SYNCSORT Splitting the file based on check digit

vissubhai · New User Joined: 07 Nov 2007 Posts: 12 Location: Hyderabad

Hi All..

I have a small requirement. I have different kinds of files with different record layouts. But the key for these files is present in the same location.(Starting 2 positions)

The key field is of 3 byte ZD field.

Now I want to split a file based on the following logic:
Divide the key field by 3 and based on the remainder move that record to the files accordingly.
That is if the remainder is 0, move the record to file1,
if remainder is 1, move the record to file 2 and
if remainder is 2, move the record to file 3.

Lets say for example my input file is a FB with LRECL=80 and the input records are as follows:

120AAAAAA
121ABCDEF
122BCDEFG
123UUUUUU
124IIIIIIIII
125QQQQQ

The three output files should be like:

Output 1
120AAAAAA
123UUUUUU

Output 2
121ABCDEF
124IIIIIIIII

Output 3
122BCDEFG
125QQQQQ

Also the same sort card should be used for other files with different record-lengths like FB with LRECL=8000 or 900 etc.

Please let me know if the requirement is not clear.

Vissubhai

Alissa Margulies · Posted: Wed Mar 19, 2008 8:56 pm

vissubhai,

SORTIN can consist of concatenated data sets, but if the data sets are fixed-length, they must all have the same LRECL.

vissubhai · New User Joined: 07 Nov 2007 Posts: 12 Location: Hyderabad

Alissa,

My requirement is can I have only one sort card for different files.

SORTIN will have only One input file and will have SORTOF01, SORTOF02, SORTOF03 files with record length same as of input file.

That is I have different JCLs for different files but wanted to use the same sortcard for them.

Let me know if I am not clear.

Thanks,
Vissubhai

Alissa Margulies · Posted: Wed Mar 19, 2008 9:58 pm

With FB data, the LRECL needs to be coded accordingly in the inrec/outrec statements, as follows:

dick scherrer · Posted: Wed Mar 19, 2008 10:32 pm

Hello,

vissubhai · New User Joined: 07 Nov 2007 Posts: 12 Location: Hyderabad

Thanks a lot Alissa...