Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
can we write a jcl to compare two files ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
neha rani

New User


Joined: 03 Jan 2007
Posts: 4
Location: bangalore

PostPosted: Wed Jan 10, 2007 10:50 am    Post subject: can we write a jcl to compare two files ?
Reply with quote

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.
Back to top
View user's profile Send private message

sattar_engg
Warnings : 1

New User


Joined: 23 Sep 2006
Posts: 4
Location: SE

PostPosted: Wed Jan 10, 2007 11:58 am    Post subject: Re: can we write a jcl to compare two files ?
Reply with quote

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'
Back to top
View user's profile Send private message
neha rani

New User


Joined: 03 Jan 2007
Posts: 4
Location: bangalore

PostPosted: Wed Jan 10, 2007 1:12 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed Jan 10, 2007 1:14 pm    Post subject:
Reply with quote

Do you have ISPF?

O.
Back to top
View user's profile Send private message
neha rani

New User


Joined: 03 Jan 2007
Posts: 4
Location: bangalore

PostPosted: Wed Jan 10, 2007 1:24 pm    Post subject:
Reply with quote

yep
i have ................
Back to top
View user's profile Send private message
neha rani

New User


Joined: 03 Jan 2007
Posts: 4
Location: bangalore

PostPosted: Wed Jan 10, 2007 1:29 pm    Post subject:
Reply with quote

thanks sattar_engg the utility worked
Back to top
View user's profile Send private message
sattar_engg
Warnings : 1

New User


Joined: 23 Sep 2006
Posts: 4
Location: SE

PostPosted: Wed Jan 10, 2007 1:34 pm    Post subject: Re: can we write a jcl to compare two files ?
Reply with quote

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
Back to top
View user's profile Send private message
mfqueen

New User


Joined: 12 Oct 2010
Posts: 1
Location: Delhi

PostPosted: Tue Oct 12, 2010 2:17 pm    Post subject: Reply to: can we write a jcl to compare two files ?
Reply with quote

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
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Oct 12, 2010 2:34 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2285
Location: @my desk

PostPosted: Tue Oct 12, 2010 2:36 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
pullaiah.cts

New User


Joined: 02 Sep 2010
Posts: 50
Location: Pune

PostPosted: Sat Jun 04, 2011 12:06 pm    Post subject: Reply to: can we write a jcl to compare two files ?
Reply with quote

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.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Sat Jun 04, 2011 12:12 pm    Post subject: Reply to: can we write a jcl to compare two files ?
Reply with quote

why not RTFM Yourself
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/ISPZPM70
or hit PF1 and read the online ISPF help ?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Sat Jun 04, 2011 12:16 pm    Post subject: Re: Reply to: can we write a jcl to compare two files ?
Reply with quote

pullaiah.cts wrote:
Hi sattar_engg,

[...]


Last post he/she made was 14 November 2007. Don't wait up.

If you have a question, start a new topic, with the details, example of input/output. Makes things easier to follow
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us