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

Listing Matching Records using 3.13 SUPER CE


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Nov 08, 2011 4:06 am
Reply with quote

Did you try Dick's suggestion from 18:35 today?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Nov 08, 2011 8:22 am
Reply with quote

Hello,

My 1.3 manual shows that WHEN=GROUP is supported. I suspect the problem is the syntax. I don't have a 1.3 Syncsort system to experiment on.

I also suspect that my "Code'd" correction is not aligned properly because the "stuff" i coded had been modified before i got there. . .

My home pc does not have the Syncsort documentation (something i plan on correcting soon) icon_smile.gif

If someone reminds me on Tuesday, i'll copy/paste a small example from the 1.3 manual icon_wink.gif
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Tue Nov 08, 2011 8:57 am
Reply with quote

Hi,

this link points to SyncSort for z/OS Release 1.3.2 supporting WHEN=GROUP

ibmmainframes.com/viewtopic.php?t=49755&highlight=wer268a+syncsort+group


Gerry
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Tue Nov 08, 2011 11:41 am
Reply with quote

Hi,
Superc with long listing provides both the matched and difference records,
if we have a SORT step to omit unwanted(insertions/deletions) records then we would have only the matched records in output,

A crude test job,
Code:


//SUPERC  EXEC PGM=ISRSUPC,       
//            PARM=(LONGL,LINECMP,
//            '',                 
//            '')                 
//NEWDD  DD DSN=WELLS.NEWFILE, 
//          DISP=SHR             
//OLDDD  DD DSN==WELLS.OLDFILE,   
//          DISP=SHR             
//OUTDD  DD DSN=WELLS.SUPERC.LIST,DISP=OLD
//*
//JS010    EXEC PGM=SORT                                               
//SORTIN   DD DISP=SHR,DSN=WELLS.SUPERC.LIST                         
//SORTOUT  DD DISP=OLD,DSN=WELLS.MATCHING.LINES                             
//SYSOUT   DD SYSOUT=*                                                 
//SYSIN DD *                                                           
  OPTION COPY                                                           
  OMIT COND=((1,5,SS,EQ,C' ID  '),OR,                                   
             (1,5,SS,EQ,C' D - '),OR,                                   
             (1,5,SS,EQ,C' I - '),OR,                                   
             (1,5,SS,EQ,C'1  IS'),OR,                                   
             (1,5,SS,EQ,C' NEW:'),OR,                                   
             (1,36,CH,EQ,C'                                    '),OR,   
             (1,36,CH,EQ,C'                      LISTING OUTPUT'),OR,   
             (1,25,CH,EQ,C'     ----+----1----+----2'))                 
/*                                                                     


I am open to corrections
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Nov 08, 2011 8:13 pm
Reply with quote

Hello,

Quote:
My 1.3 manual shows that WHEN=GROUP is supported.
My bad . . . icon_redface.gif

My 1.3 documentation includes changes up thru 1.3.2 - which has the WHEN=GROUP support. I must have replaced the original 1.3 material with the newer update. The 1.3.1 does not support WHEN=GROUP as has been mentioned. Apologies for the false lead. . . icon_neutral.gif

@Nageshwar Rao Vedula - as even 1.3.2 has been around for quite a while, possibly your product could be upgraded to the newest 1.4 which has WHEN=GROUP and a whole lot more.
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 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
Search our Forums:

Back to Top