Shazzzbot... tried to reformat so it may be understood better and I
still mess it up. Sorry
What I'm attempting to do is compare two files and;
1) report any differences found within a certain column range and
2) any added or deleted records.
I have two test files I'm working with that have 20 records each.
The files are exact until I made these changes to the one I'll call NEW
(Key is the first 9 digits of the record)
1) record key 999999999 deleted from NEW
2) record key 999999995 had data changed in cols 999-1004
3) record key 999999992 also had data changed
4) record key 999999989 was ADDED to the NEW file
RESULTS
When I execute SUPERC with no process statements the output from SUPERC
seems as I would expect
run with Compare Type = FILE Listing type = Delta and NO process
options)
D - 999999999 3J90004514W5 M38 3 ROGERS
I - 999999995 3390000361D1 FVV 1 ALPHA REC
D - 999999995 3390000361D1 FVV 1 ALPHA REC
I - 999999992 5390002361D3 FVV 1 CONVERT EXPECT
D - 999999992 5390002361D3 FVV 1 CONVERT EXPECT
I - 999999989 5390005361D6 F 6 FODDER
But this shows records with changes in ANY column.
Not what we are looking for.
When I add the CMPCOLM 999:1004 statement and rerun the compare, the
output is befuddling to me as it is entirely different. I would have
expected the same as above as the changes were within those columns.
I - 999999995 3390000361D1 FVV 1 ALPHA REC
I - 999999994 4390001361D2 FVV 1 EXPECT CONV
I - 999999992 5390002361D3 FVV 1 CONVERT EXPECT
D - 999999993 3369332501M3 F17 1 CKATZ
D - 999999991 4390004361D5 F17 1 CCAROL
D - 999999990 4390005361D6 UVV 1 DUEINFOURMOS
There seems to be an additional I (insert) listed (key 999999994).
Note: There was no change to record 999999994
And what are all the D (deletes) listed?
It also doesn't show the delete or inserted records (999999999 and
999999989).
I've tried a number of other options and statements...
Any insights would be appreciated!
Thanks
Bill
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
