IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Compare two sequential datasets using JCL


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Wed Jan 11, 2006 2:11 pm
Reply with quote

How to compare two sequential datasets using JCL similar to that of 3.12(SUPERC)? I want the output in a dataset similar to the output of SUPERC?
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463

PostPosted: Wed Jan 11, 2006 2:25 pm
Reply with quote

HI
Try the following JCL

Code:
//CMPRTST1 JOB (ACCT#),'SORT  ',NOTIFY=&SYSUID,CLASS=T,MSGCLASS=X 
//SUPERC  EXEC PGM=ISRSUPC,                                       
//            PARM=(DELTAL,LINECMP,                               
//            ' SEQ',                                             
//            '')                                                 
//NEWDD  DD DSN=First File,                           
//          DISP=SHR                                               
//OLDDD  DD DSN=Second File,                           
//          DISP=SHR                                               
//OUTDD  DD DSN=Output file,                           
//          DISP=OLD                     



Hope this helps
Regards
Rupesh
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Wed Jan 11, 2006 2:44 pm
Reply with quote

Hi Anton,

Addint to Rupesh JCL this is also b used to compare two DS

Code:
//JOB1 JOB A50, 'name'
//STEP1 EXEC PGM=IEBCOMPR
//SYSOUT DD SYSOUT=*
//SYSUT1  DD DSN=DSNNAME,DISP=SHR
//SYSUT2  DD DSN=DSNNAME,DISP=SHR
//SYSIN    DD *

 COMPARE TYPORG=PO/PS
/*
//


Try and say wheather the results are same or it differs??? icon_cool.gif
Back to top
View user's profile Send private message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Wed Jan 11, 2006 8:49 pm
Reply with quote

Thanks Rupesh and Khamarutheen. I will try and let you people know.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Wed Jan 11, 2006 10:17 pm
Reply with quote

antonrino.b,

Quote:
How to compare two sequential datasets using JCL similar to that of 3.12(SUPERC)? I want the output in a dataset similar to the output of SUPERC?

Did you notice these options at the bottom of the screen while using SUPERC or 3.12 ?

Code:
Enter "/" to select option      Execution Mode          Output Mode
   Mixed Mode                   1  1. Foreground        2  1. View 
   Bypass selection list           2. Batch                2. Browse


Execution Mode: If given 2, will take you for further options & at last you'll be able to view/edit the JCL being submitted for that.

Regards,

Priyesh.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 496
Location: USA

PostPosted: Wed Feb 04, 2009 12:25 am
Reply with quote

It sounds like you may be able to use SyncSort's JOIN feature for this, but without seeing sample input and an example of the desired output, I cannot provide you with any specifics.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Compare two files with a key and writ... SYNCSORT 3
No new posts Compare latest 2 rows of a table usin... DB2 1
No new posts How to compare two rows of same table DB2 11
No new posts Merging 2 datasets into one DFSORT/ICETOOL 1
Search our Forums:

Back to Top