Fetching records of a file via SYNCSORT

skrishnavijay · New User Joined: 26 Sep 2007 Posts: 25 Location: chennai

Hi all,

I have the following requirement.

There are two files with some similar records(say file A has more records then file B). My intention is to get those records which are in file A and NOT in file B (i..e.. A - B).

Krishna

murmohk1 · Posted: Fri Dec 07, 2007 10:03 pm

Krishna,

If you are interested in using DFSORT util, follow the link -

www.ibmmainframes.com/viewtopic.php?t=5797&highlight=compare

Frank Yaeger · Posted: Fri Dec 07, 2007 10:40 pm

Krishna,

You haven't given enough information.

Please show an example of the records in each input file (relevant fields only) and what you expect for the output records. If input fileA can have duplicates within it, show that in your example. If input fileB can have duplicates within it, show that in your example.

Give the starting position, length and format of the relevant fields.

Give the RECFM and LRECL of each input file.

skrishnavijay · New User Joined: 26 Sep 2007 Posts: 25 Location: chennai

File 1:

LRECL=80, (1,21,CH,A) Key position

000000000000000000024|........
000000000000000000132|........
000000000000000000024|........
000000000000000001879|........
000000000000000002134|........
000000000000012084883|........
000000000000000321833|........
000000000000000002134|........
000000000000000032156|........

File 2:

LRECL=80, (34,21,CH,A) Key position

..............................000000000000000000024|........
..............................000000000000000000132|........
..............................000000000000000000024|........
..............................000000000000000001879|........
..............................000000000000000002134|........
..............................000000000000000321833|........
..............................000000000000012084883|........

here File2 is subset of File1. I want records in File1 and NOT in File2.
I need to concern about Key field only and both file1 and file2 have duplicates.

Hope I am clear.

Thanks in advance,
Krishna

Frank Yaeger · Posted: Fri Dec 07, 2007 11:50 pm

skrishnavijay · New User Joined: 26 Sep 2007 Posts: 25 Location: chennai

Thanks for your patience.

I forgot to mention that my input & output files are fixed length(FB 80)

Yes.

As you said I want one of the records(duplicates) in file1 those doesn't have a match in file2 (I want the full record from file1)

Also we are using SYNCSORT. Could you please help me in this regard ?

Thanks in advance,
Krishna

shankar.v · Posted: Mon Dec 10, 2007 1:36 pm

skrishnavijay,

Please check with the following code for for your requirement.

skrishnavijay · New User Joined: 26 Sep 2007 Posts: 25 Location: chennai

Thanks a lot Shankar......!!

You are very helpful... Its working gr8.......!!!

Thanks,
Krishna