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

compare three PS file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dheerajyermal

New User


Joined: 20 Sep 2010
Posts: 6
Location: banglore

PostPosted: Fri Oct 08, 2010 9:02 am
Reply with quote

AS we have compare(comp x) two compare two PS file
i need a jcl which compares three PS file.

In our project we need to keep sync of three PS file,if i do com x its time consuming so i need a jcl which compare three PS file at a time.
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: Fri Oct 08, 2010 9:08 am
Reply with quote

Hello,

To get any help here, you need to post some sample data from the 3 input files and the output you want from that sample input.

Mention the dsorg and lrecl of all of the files.

Explain the rules for the compare showing the relevant data positions and how duplicate or missing entries are to be handled. The test data should contain some of each condition that might occur in the real data.

The sample data does not need to be high volume.
Back to top
View user's profile Send private message
dheerajyermal

New User


Joined: 20 Sep 2010
Posts: 6
Location: banglore

PostPosted: Fri Oct 08, 2010 2:57 pm
Reply with quote

Hello,

I have 3 input files member of PDS and want to create output files for the following:
* matched key that appear on both file1,2 and 3
* key that appears only on file1
* key that appears only on file2
* key that appears only on file3

These 3 input files are Fixed Block, recl=80, key is in same place,
Output file is also FB, recl=80;

There is no condition, just i need to comapre as we do in 3.13 option.
in 3.13 we do fr 2 files here i need jcl for 3 files and need output to show the difference between the files.
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 577
Location: USA

PostPosted: Fri Oct 08, 2010 5:19 pm
Reply with quote

dheerajyermal,
What are the field positions for keys in all three files? Could you have duplicates in any of the three files?

Thanks,
Back to top
View user's profile Send private message
dheerajyermal

New User


Joined: 20 Sep 2010
Posts: 6
Location: banglore

PostPosted: Fri Oct 08, 2010 5:54 pm
Reply with quote

thx for reply

just i need to compare three cobol programs. no need of key and all.
only comparison
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Fri Oct 08, 2010 6:18 pm
Reply with quote

Quote:
just i need to compare three cobol programs. no need of key and all.


do You realize that processing source code is different from processing files
for comparison that is even more true

it' s You that started talking about keys

if You can download the files/members to Your workstation there is tool already available for that,
it is called DIFF3 and You can find a download googling for it

it' s purpose is especially for finding difference between source files
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 8
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
Search our Forums:

Back to Top