Comparing two datasets using SuperCE for specific columns
As all we know SuperCE allows the comparison of the datasets. Generally we use it to compare the whole datasets. But some times we may require comparing the datasets according to the data present in the specified location (ex: from col 15 to col 20).
Enter in to SuperCE screen (3.13) from the ISPF main menu.It looks like the below sample
screen:_____________________________________________________Menu Utilities Options Help
BSYS SuperCE Utility
New DS Name . . . 'BOPSNA.T.TECHM.MG3289.TEST1'
Old DS Name . . . 'BOPSNA.T.TECHM.MG3289.TEST2'Member List (blank/pattern - member list, * - compare all)
(Leave New/Old DSN "blank" for concatenated-uncataloged-password panel)
Compare Type Listing Type Display Output
2 1. File 2 1. OVSUM 1 1. Yes
2. Line 2. Delta 2. No
3. Word 3. CHNG 3. Cond
4. Byte 4. Long 4. UPD
Listing DSN . . . . 'BOPSNA.T.MG3289.COMP'
Enter in to Edit Options Tab
There you can give the column options from where you want to compare the data sets.
Here if you want to compare the datasets based on the data present from the columns 1 to 5 you can mention the options as COMPCOLM 1:5
Likewise there are some different options that you can give to process the comparison. You can see the examples in that screen
Process Options:We can change the process options depending upon our compare requirement. Generally the default option is COBOL.
In the next screen select the option by entering ‘/’ in front of the option you want.
Detailed process options:You can find the detailed explanation on the Process options in the below IBM link.
COMPARING TWO FILES WITH DIFFERENT LAYOUTS
If you want to compare 2 files having different layouts you can do this by using 3.13.Suppose you want to compare the 100:149 (start pos:end pos) of the new file with the 200:249 (start pos:end pos) of the old file, then here is the option that you may use.
- Select 3.13
- Give new and old DSNs
- Point to the Options in the menu bar and press enter
- Select Edit Statements (1) option
- Give the options like this
- CMPCOLMN 100:149
- CMPCOLMO 200:249
The resulting JCL will look like this and it can be edited for the desired positions and can be re used.
//MG9933A JOB (00124,'SUPERC'),MAHY,
//SUPERC EXEC PGM=ISRSUPC,
//NEWDD DD DSN=MG9933.TEST.CMPR1,
//OLDDD DD DSN=MG9933.TEST.CMPR2,
//OUTDD DD SYSOUT= *
//SYSIN DD *