Processing 2 record format to find the record count

thirunarayanan_sampath · New User Joined: 04 Dec 2006 Posts: 6 Location: Pune,India

Hi all,

I currently have a situation where I have 2 fixed length file with record format Type1 and Type2 respectively:-

File1

key1,field11, field12, Type2-record-count

File2

key1,field21, field22

So for each record in File1 there could be multiple record in File2
which are linked through the key1.

I need to populate 'Type2-record-count' with the no. of occurances of records in file2.

Is is possible to use a ICETOOL to solve this problem. Can you please suggest me an idea.

Thanks and Regards,
Thiru

Frank Yaeger · Posted: Sun May 25, 2008 8:56 pm

Please show an example of the records in each input file (relevant fields only) and what you expect for output. If input file1 can have duplicates within it, show that in your example. If input file2 can have duplicates within it show that in your example. Explain the rules for getting from input to output.

Give the RECFM and LRECL of the input files. Give the starting position, length and format of each relevant field in each input file.

thirunarayanan_sampath · New User Joined: 04 Dec 2006 Posts: 6 Location: Pune,India

Hi Frank,

Please find the details of the file information and its records

File 1

Sort Code No of occurance in file2
(key field/no duplicates)

123456 02
123457 03
123458 04

File 2

Sort Code Party Id
(Key field/with dup) (duplicates allowed but not for same key field)

123456 1111111111
123456 2222222222

123457 1111111111
123457 3333333333
123457 5555555555

123458 1111111111
123458 1111111115
123458 1111111114
123458 1111111113
123458 1234567890

Frank Yaeger · Posted: Wed Jun 04, 2008 8:53 pm

Are you saying that you want to count the number of values for a key in file2, and overlay that count into the No of occurance field in file1 for that key?

In your example, are you showing the input for file1 and file2? If so, would the output for your example be:

thirunarayanan_sampath · New User Joined: 04 Dec 2006 Posts: 6 Location: Pune,India

Hi Frank,

Yes the requirement is to count the number of values for each key in file2 and overlay the count into '' No of occurance'' field in file1.

Yes Eventually, the count should be updated in the file1 and output is :-

file1

123456 02
123457 03
123458 05

LRECL of both files = 80
key field start at pos 1 for both files and of 6 characters in length.

''No of occurance'' field in file1 starting position = 7, length = 2

''Party id'' field in file2 starting posiyion = 7, length = 10

Skolusu · Posted: Thu Jun 05, 2008 10:49 pm

thirunarayanan_sampath,

The following DFSORT/ICETOOL JCl will give you the desired results