Joined: 22 Mar 2009 Posts: 161 Location: South Africa
Hi,
I have two i/p files whose recl and the format are same. Record length is 500. I have to do comparison as per below condition
Compare first 1-388(key1) and then 393-500 (Key2) . Matched records will go to the Match1 file and unmatched records will go to the UNMAT1 file.
If you need more specific help, show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.
Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:
Joined: 22 Mar 2009 Posts: 161 Location: South Africa
The two i/p files recfm is fixed and the LRECL is 500. I need to compare the records as follows:
file1's 1-388 length will be compared with file2's 1-388 length and then
file1's - 393-500 length will be compared with file2's 393-500 length and
and from position 389-392 should be ignored.
The o/p file should only contain the unique records.
File1's record count is : RECORD COUNT = 11633753
File2's record count is : RECORD COUNT = 11630895
Joined: 22 Mar 2009 Posts: 161 Location: South Africa
Actually I have made some changes to my cobol program. And due to that the file after run is showing more records than before run. I need to find the extra records and need to analyse why these extra records came. I had only done changes from 389-392 position of the file . So, in both the file this particular fields may/may not vary but there should not be no mismatch in the record count. So, that is the reason I need the unique records in my o/p file.
Joined: 22 Mar 2009 Posts: 161 Location: South Africa
I reduced the size of the i/p files and now its running fine. But in the output file no records are coming only trailer records are coming.
i.e.
FILE1 RECORD COUNT = 48
FILE2 RECORD COUNT = 48
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
I reduced the size of the i/p files and now its running fine. But in the output file no records are coming only trailer records are coming.
i.e.
FILE1 RECORD COUNT = 48
FILE2 RECORD COUNT = 48
But i need the unique records also.
Sigh. In my first post, I said:
Quote:
If you need more specific help, show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.
The only output you showed was the record counts, so that's what I gave you. Now you complain that it isn't the correct output. Sheesh.
If you want the unique records as well as the record counts, change your CTL3CNTL statements to:
Code:
//CTL3CNTL DD *
OUTFIL FNAMES=OUT,REMOVECC,
BUILD=(1,500),
TRAILER1=('FILE1 RECORD COUNT = ',
TOT=(501,1,ZD,M10,LENGTH=8),/,
'FILE2 RECORD COUNT = ',
TOT=(502,1,ZD,M10,LENGTH=8))
If that doesn't give you what you want, then you need to give me ALL of the information I asked for.
Quote:
I am getting S0B37 error with the ICETOOL option. Can anyone have idea
A B37 means you haven't given large enough SPACE values for the data set that's getting the B37. You need to increase the SPACE values. Of course, since you didn't tell us which data set you got the B37 for, what SPACE parameters you used, how many records you had, etc, we can't help you much.
You really need to learn how to do a better job of giving information if you want people to help you.
