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

Compare 2 PS datasets


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 463

PostPosted: Fri Oct 14, 2005 11:29 am
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
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 Developer


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

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

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

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 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