can we write a jcl to compare two files ?

neha rani · New User Joined: 03 Jan 2007 Posts: 4 Location: bangalore

hi all

is there any utility in jcl to compare two files and write the differences in
third file ?
i tried using sort but tht didt work tht needs a sort key but i need to compare the whole records as i dont know where the changes are .

Thanks everybdy fer their help.

sattar_engg · New User Joined: 23 Sep 2006 Posts: 5 Location: SE

hi,
you can use utility ISRSUPC
please find the jcl ....'

//star001 JOB MSGCLASS=T,MSGLEVEL=(1,1),NOTIFY=&SYSUID
//*MAIN ORG=NIADQ,CLASS=TEST
//SUPERC EXEC PGM=ISRSUPC,
// PARM=(DELTAL,LINECMP,
// '',
// '')
//NEWDD DD DSN=star.DATA.SALES.C.JCL(tempnew),
// DISP=SHR
//OLDDD DD DSN=star.old.pds(tempold),
// DISP=SHR
//OUTDD DD SYSOUT=(A)
//SYSIN DD *
*CMPCOLM 1:167 194:364 370:678
LSTCOLM 1:80
CMPCOLM 1:80
*CMPCOLM 101:125
/*
//

Abdul sattar
'Help others with out expecting any thing from the'

neha rani · New User Joined: 03 Jan 2007 Posts: 4 Location: bangalore

it seems tht my system doesnt recognize isrsupc utility i tried with tht
but it says invalid pgm name and thn it discard it .
can it happen tht systems doesnt recognize some utilities ?
is there no other way of doin it?

thank u

ofer71 · Posted: Wed Jan 10, 2007 1:14 pm

Do you have ISPF?

O.

neha rani · New User Joined: 03 Jan 2007 Posts: 4 Location: bangalore

yep
i have ................

neha rani · New User Joined: 03 Jan 2007 Posts: 4 Location: bangalore

thanks sattar_engg the utility worked

sattar_engg · New User Joined: 23 Sep 2006 Posts: 5 Location: SE

if you have ISPf then
go to 3.13 and select Execution Mode as 2 i.e batch.

give your new and old data sets. press enter to get JCL and the utility it is using...

find attachment for the same
abdul sattar

mfqueen · New User Joined: 12 Oct 2010 Posts: 1 Location: Delhi

Hi , Could someone please explain the comparison programming for the sysin control card used in the above mentioned jcl as to how to compare two files.

Thanks in advance

dbzTHEdinosauer · Posted: Tue Oct 12, 2010 2:34 pm

ISPF option 3.12 (as well as all the ISPF 3.nn routines)
has excellent online help (PF1).
there is also the manual which can be found here if you can not find the PF1 key on your keyboard.

Arun Raj · Posted: Tue Oct 12, 2010 2:36 pm

mfqueen,

Hello and welcome to the forums.

If you have a new requirement on file comparison, you can start a new topic rather than replying to an old one.

pullaiah.cts · New User Joined: 02 Sep 2010 Posts: 50 Location: Pune

Hi sattar_engg,

Thanks for your code,it's working fine but I have one more question.Your code is listing all the differences between two files but If I want to compare FILE1 and FILE2 and write only the records((not the differences) that are not in the FILE1 then what's the code?

Please help me.

enrico-sorichetti · Posted: Sat Jun 04, 2011 12:12 pm

why not RTFM Yourself
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/ISPZPM70
or hit PF1 and read the online ISPF help ?

Bill Woodger · Posted: Sat Jun 04, 2011 12:16 pm