DFSORT to compare 2 files (in place of SUPERC)



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

DFSORT to compare 2 files (in place of SUPERC)

Postby jawaharsmg » Fri May 07, 2010 9:50 pm

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                                     
/*
jawaharsmg
 
Posts: 16
Joined: Tue Feb 16, 2010 8:47 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby Frank Yaeger » Fri May 07, 2010 10:24 pm

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

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

Postby jawaharsmg » Fri May 07, 2010 10:53 pm

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
jawaharsmg
 
Posts: 16
Joined: Tue Feb 16, 2010 8:47 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby Frank Yaeger » Fri May 07, 2010 11:14 pm

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post