Matching records between 3 files

Indrajit_57 · New User Joined: 27 Jun 2006 Posts: 60

Hi,

My requirement is to find records present in File 1 (Fixed length Flat file) which are either present in File 2 (Fixed length VSAM File) or File 3 (Fixed length VSAM file). File 2 and 3 are of the same record length. File 1, 2 and 3 have keys starting at 1 position and is of length 5 bytes.

File 1 will not have any duplicate record and the records will definitely be present in either File 2 or File 3.

When a match is found then the entire record from File 2 or File 3 (wherever it is found) needs to be written into a flat output file.

For example,

File 1 (FB/80 bytes)

00001ABC
00004DEF
00007GHI

File 2 (VSAM/1000 bytes)
00001ABCTHIS IS A TEST DATA 1
00002PQRTHIS IS A TEST DATA 2
00003XYZTHIS IS A TEST DATA 3
00004DEFTHIS IS A TEST DATA 4

File 3 (VSAM/1000 bytes)
00007GHITHIS IS A TEST DATA 5
00009LMNTHIS IS A TEST DATA 6

The output should be (FB/1000 bytes)
00001ABCTHIS IS A TEST DATA 1
00004DEFTHIS IS A TEST DATA 4
00007GHITHIS IS A TEST DATA 5

Can this be performed in a single step?

Thanks,
Indrajit
[/code]

Skolusu · Posted: Mon Nov 26, 2012 11:51 pm

Indrajit_57,

Aren't using Syncsort? This Forum is for DFSORT related questions. Please post your questions in the JCL forum.

Thanks

Pandora-Box · Posted: Tue Nov 27, 2012 12:13 am

Indrajit,

Did you close all queries in your open threads?

Moderators,

Please lock this thread until he closes the open threads all lead to some dangling pointer