Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Compare 2 PS datasets

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

New User


Joined: 20 Sep 2005
Posts: 6

PostPosted: Fri Oct 14, 2005 9:44 am    Post subject: Compare 2 PS datasets
Reply with quote

Hi,

I have a query.. There are 2 datasets A and B.
How do I retrieve the records which are in A but not in B?? Please help.
I used SUPERCE utility. It gives just the no.s of the unpaired records. How do I get the actual unpaired records??

Cheers
Anu
Back to top
View user's profile Send private message

Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Fri Oct 14, 2005 11:29 am    Post subject: Re: Compare 2 PS datasets
Reply with quote

HI,

This type of question already discussed in forum, Please make search you will get your answer.

Regards

Rupesh
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Sun Oct 16, 2005 7:32 pm    Post subject:
Reply with quote

If you are using 3.13 to do a compare and you cannot see the difference you must set a different request in Listing Type:
These are the value of this menu:
Code:
_  1. OVSUM 
   2. Delta 
   3. CHNG   
   4. Long   
   5. Nolist

These explanation are from the help of SUPERCE:
Code:
 OVSUM  Lists only the overall summary of the data set or PDS comparison.   
        If partitioned data sets are compared, the listing includes a summary
        line for each member selected from the PDS.                         
 Delta  Lists the differences between the source data sets, followed by the   
        overall summary results.  Differences are flagged to the left of each 
        output line.                                                           
                                                                               
 CHNG   Lists the differences between the source data sets, plus up to 10     
        matching output lines before and after the differences.  This listing 
        is like the delta listing, but includes surrounding matched lines as an
        aid in recognizing changed areas of the source data sets.             
                                                                               
 Long   Lists the complete new data set with the old data set deleted data     
        interspersed in the output listing.  Both inserted and deleted output   
        data is flagged. The format is the same as the DELTA with all matching 
        data shown.                                                             
                                                                               
 Nolist No listing output is produced.  A ISPF message displayed after         
        the SuperC program execution is the sole method to determine the results
        of the compare operation.  You may wish to use the NOLIST option when   
        you use one of the UPDATE comparison options to generate an update data
        set and the listing is unimportant.                                     
                                                                               
 NOTE:  The listing type default for Line, Word, and Byte compare is DELTA.     
        The listing type is ignored for File compare as other File compare     
        process options are used to determine the listing requirements.         


I think that you have set the OVSUM option, try to change it! icon_wink.gif

This method has some limit and if you want to compare with other tool your file I suggest you as Rupesh say to search in this forum or in DfSort because there are really interesting alternative to 3.13

I hope in this help.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Sun Oct 16, 2005 9:04 pm    Post subject:
Reply with quote

See the following Smart DFSORT Trick for some techniques you can use with DFSORT/ICETOOL to do this kind of thing:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t05
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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts COMPARE command sivatechdrive TSO/ISPF 7 Fri Sep 16, 2016 4:31 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us