Page 1 of 1

DFSORT to compare 2 files (in place of SUPERC)

PostPosted: Fri May 07, 2010 9:50 pm
by jawaharsmg
Hi ,

I have this below step being performed in SUPERC with specific columns to be compared and the full file on the new/ old be listed.
However SUPERC does not list all the fields and restricts to 72.

Is there an option to do the same thing in DFSORT. Any help is appreciated. Thanks


//SUPERC  EXEC PGM=ISRSUPC,                       
//            PARM=(DELTAL,LINECMP,               
//            '',                                 
//            '')                                 
//NEWDD  DD DSN=dataset1,
//          DISP=SHR                               
//OLDDD  DD DSN=dataset2,
//          DISP=SHR                               
//OUTDD     DD SYSOUT=*                           
//SYSIN  DD *                                     
CMPCOLM 1:524 531:537 543:548 552:1000             
LSTCOLM 1:1000                                     
/*

Re: DFSORT to compare 2 files (in place of SUPERC)

PostPosted: Fri May 07, 2010 10:24 pm
by Frank Yaeger
I don't know SUPERC well enough to figure out what that job does.

Please 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.

Re: DFSORT to compare 2 files (in place of SUPERC)

PostPosted: Fri May 07, 2010 10:53 pm
by jawaharsmg
Frank,
There wont be any duplicates in either of the two input files.

SUPERC is a utility which we can access from 3.13 option on ISPF.

What I am doing here is comparing those two inputs byte - to byte and listing the two file records on the output file - if there is a difference between them on any of those fields I am comparing.

Here I am comparing,
columns 1 -524 , then 7 bytes starting col 531, 6 bytes starting col 543 and 449 bytes starting col 552.

Hope this explains.

thanks

Re: DFSORT to compare 2 files (in place of SUPERC)

PostPosted: Fri May 07, 2010 11:14 pm
by Frank Yaeger
Yes, I know what SUPERC is. What I don't know is what you want for output.

Again:

Please 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.