JCL for comparison of flat files of variable length

kayelan · New User Joined: 01 Dec 2006 Posts: 13 Location: frankfurt

Hi everyone,

I hv 2 flat files of variable length and records > than 20000. Let me explain the file structure:
<Fixed part>+ <n* Variable parts>
Every record has a fixed part with n number of Variable parts extended after the fixed part.
Record Layout For example..
FIXED PART-----------| VAR PART 1 | VAR PART 2 | VAR PART 3 |:::::::::

Requirements:

1. Need to compare two files

2. No. of records in both the files differ
For ex., File-1 will have 20 records and File-2 will have 30 records. The utility has to pick up only the same records and neglect the rest.

3. There are certain exceptional fields in the file which are to be omitted for comparison. i.e., even if the specified field differs in both the files, it is assumed the records match exactly .

4. There is a key field in one of the variable part that acts as a starting point to map a record in one file to other file

Need a JCL to do all the steps mentioned above.

Kindly help

PeD · Posted: Fri Dec 01, 2006 11:55 pm

kayelan · New User Joined: 01 Dec 2006 Posts: 13 Location: frankfurt

Record structure looks like following:

Fixed part - 20 bytes
Variable part-5 bytes
In Fixed part the last field will contain no. of Variable parts following it.

Ex:
abcdefghijklmnopqr0501aaa02bbb03ccc04ddd05eee

05 in red colour shows no. of Variable parts.
Green and Blus show the variable parts

PeD · Posted: Mon Dec 04, 2006 3:54 pm

One more question : does any occurence of variable part is always fixed. I mean all VAR PART n have the same length.

The variable part of record is only conditionned by field with "05" in this case, but which can be "03", "07", etc ...