MVSFORUMS.com

Nork1 · Beginner Joined: 22 Jan 2004 Posts: 4 Topics: 2

Hi.

I've been trying unsuccessfully to come up with a method of comparing records in a file and removing any in which data matches on parts of those records.

REC1 AGBNC#GB01DAY A NCU1 003 PGBNCA0D N
REC2 AGBNC#GB01DAY A NCU1 007 PGBNCA1D N
REC3 BGBNC#GB01DAY A NCU2 003 BGBNCA0D N
REC4 BGBNC#GB01DAY A NCU2 007 BGBNCA1D N
REC5 BGBNC#GB01DAY A NCU2 009 BGBNCA3D N

In the example above I want to ignore characters in columns 1, 23 and 29 (bold characters).
Ignoring these columns, records 1 and 3 match and are counted as duplicates as are records 2 and 4. The only non-matching record is 5 which is to be written to an output file.

Unfortunately I'm only a beginner on ICETOOL and my attempts so far have proved unsuccessful. Your help will be greatly appreciated.

Thanks!

kolusu · Posted: Fri Jan 23, 2004 6:56 am Post subject:

Nork1,

The following JCL will give you the desired results. The postions you want to eliminate are 1, 20, 26 ( as shown by you in bold) . so you can specify the sort fields without them and get the desired results.

Nork1 · Beginner Joined: 22 Jan 2004 Posts: 4 Topics: 2

Kolusu,

Thanks for the prompt response... much appreciated!