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 datasets

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
aniceg
Warnings : 1

New User


Joined: 04 Apr 2008
Posts: 10
Location: chennai

PostPosted: Fri Jan 09, 2009 4:15 pm    Post subject: Compare datasets
Reply with quote

I need to compare two PS files
The order of content is different in the two files
There is no key by which i can sort the file
I need to get the differences between two files but it should not show the difference in position as a difference
Can anyone of you please say me if it can be done superC
Back to top
View user's profile Send private message

UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 755
Location: Germany

PostPosted: Fri Jan 09, 2009 4:20 pm    Post subject:
Reply with quote

Hi aniceg !

What was the result of your attempt to solve it via SuperC ???
Please let us know, thank's
Back to top
View user's profile Send private message
aniceg
Warnings : 1

New User


Joined: 04 Apr 2008
Posts: 10
Location: chennai

PostPosted: Fri Jan 09, 2009 4:28 pm    Post subject:
Reply with quote

It showed the difference in position also as a difference which i didnt want
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Fri Jan 09, 2009 8:38 pm    Post subject:
Reply with quote

Helllo,

Sort both files into some arbitrary sequence (account, amount, and date for example). Then compare the files with superc. This will show the differences in the data and not the positon.
Back to top
View user's profile Send private message
aniceg
Warnings : 1

New User


Joined: 04 Apr 2008
Posts: 10
Location: chennai

PostPosted: Sat Jan 10, 2009 3:37 pm    Post subject:
Reply with quote

There is no unique field by which sorting can be done
So i need to compare without sorting
Back to top
View user's profile Send private message
souravmitra

New User


Joined: 19 Feb 2008
Posts: 3
Location: Kolkata

PostPosted: Sat Jan 10, 2009 11:43 pm    Post subject: Reply to: Compare datasets
Reply with quote

If you dont require the difference in position, then go for a search options as we used to find a particular string.

this suggestion is only valid if both the file contains almost same data only but not in same sequence.
If anyone has any better idea please share ..

if my understanding on your requirement is wrong please revert back.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Sun Jan 11, 2009 12:07 am    Post subject: Reply to: Compare datasets
Reply with quote

quoting fo clarity the starting message
Quote:
I need to compare two PS files
The order of content is different in the two files
There is no key by which i can sort the file
I need to get the differences between two files but it should not show the difference in position as a difference
Can anyone of you please say me if it can be done superC


superc will compare almost anything if the compare parameter are properly specified

superc is aimed at programming,
it will generate a report identifying
changed/inserted/deleted blocks of text,
it will generate, if specified, the IEBUPDTE control cards to update one dataset to the other one

so if You would please be more clear about the business requirement,
You might probably get better help

from the original request it might be inferred that You want to compare completely unrelated datasets,
it can be done, but the results would be of little value
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Sun Jan 11, 2009 12:11 am    Post subject:
Reply with quote

Hello,

Quote:
There is no unique field by which sorting can be done
So i need to compare without sorting
You have confused yourself. . .

You don't need a true sort key. You will make the compare possible by arranging the data in basically the same sequence. As is mentioned, sort both files on some arbitrary key of a few common data fields. If there is nothing in common at all between the files, there is no reason to compare them. . . icon_confused.gif

If you provide a better explannation of your requirement, we might make better suggestions.
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm


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