MVSFORUMS.com

[mahesh_chv]

Hello,

I have a requirement to create output file using two different files such a way that for the matching key record should come from first file. All non-matching records from both the files should come in output file.

Find below the scenario.

E.g.

File 1
523AAAAM01
524BBBBM01
525CCCCM01

File 2
523XXXXM01
523RRRRM01
524YYYYM01
526DDDDM01

Expected Output File :

523AAAAM01
524BBBBM01
525CCCCM01
526DDDDM01

Here the key field is pos 1 to pos 3. I am using below control card

SORT FIELDS=(1,3,ZD,A) --> To sort the records in ascending order
SUM FIELDS=NONE --> To remove the duplicates in output

I am getting the below output which is not expected.

523AAAAM01 --> Correct
524YYYYM01 --> Wrong!! it should be from File 1 i.e. 524BBBBM01
525CCCCM01 --> Correct
526DDDDM01 --> Correct

Please help me out!!....Also note that I have supplied huge input records !!

[kolusu]

mahesh_chv,

you need to concatenate file 1 first in the concatenation list and also use EQUALS option so that you have the record from file1

[mahesh_chv]

Thanks Kolusu!
your solution worked fine.....