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
 

 

Comparisions of two files with same copy book structure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
vijayprabu

New User


Joined: 15 Dec 2005
Posts: 21

PostPosted: Tue Jul 13, 2010 11:07 pm    Post subject: Comparisions of two files with same copy book structure
Reply with quote

I have two similar flat file with same copybook structure.

File1 : QACLR.ARM7.SPEC.BILLING
File2 : QACLR.ARM7.SPEC.BILLING

The primary reason to compare these two files is data validations. There are certain fields i want to compare.

Total fileds are more than 200 fields, but i want to compare five fields with one unique filed.

Can you please tell me what are all the various options i can do it.

Please ignore suggestions COBOL and Trace master. Let me know if you guys have file aid options?
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Jul 13, 2010 11:37 pm    Post subject:
Reply with quote

why should we bother to be precise, when you are not:

Quote:
File1 : QACLR.ARM7.SPEC.BILLING
File2 : QACLR.ARM7.SPEC.BILLING


looks like they are more than similar.
Back to top
View user's profile Send private message
vijayprabu

New User


Joined: 15 Dec 2005
Posts: 21

PostPosted: Tue Jul 13, 2010 11:47 pm    Post subject:
Reply with quote

Let me give some additional informations.

We backed up some files 4 months ago and now we restored the same files. Now we want to make sure both are having the same records.

In order to do that there are certain fields i need to compare by using unique.

I have mentioned duplicate file names since i shoud not mentione the original name.

S-NUM X(12)
ACCT-NUM X(8)
PRIM-NM X(2)
PTC-CD X(5)

S-NUM is a key field to compare.

What would be the easiest way to compare.
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: Tue Jul 13, 2010 11:57 pm    Post subject:
Reply with quote

Hello,

Quote:
What would be the easiest way to compare.
You said you didn't want what would possibly be the easiest way. . .
Quote:
Please ignore suggestions COBOL. . .


This is less than an hour's work in cobol and you have the complete flexibility to customize as needed. Assuming the files are in the same "key" sequence, there is working sample code to do this in a "Sticky" near the top of the COBOL part of the forum (2-file match/merge).
Back to top
View user's profile Send private message
vijayprabu

New User


Joined: 15 Dec 2005
Posts: 21

PostPosted: Wed Jul 14, 2010 12:05 am    Post subject:
Reply with quote

Thanks for your clarifications.

I am being part of QA tester side not with developement. I dont have autority to work in COBOL.

So as a tester i do have access on JCLs submissions includes SORT, fileaid tools. So I am just thinking of how to resolve it either on of there options
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 662
Location: Pennsylvania

PostPosted: Wed Jul 14, 2010 12:13 am    Post subject:
Reply with quote

What is wrong with SUPERCE?

This appears simple enough.

You can use CMPCOLM option if need be.
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: Wed Jul 14, 2010 12:19 am    Post subject:
Reply with quote

Hello,

Quote:
I dont have autority to work in COBOL.
Maybe this should be changed. . . Several of the sites i've supported had libraries and compile proedures for the "testers".

None of the test/validation code was to be promoted, just to automate things like data validation, file verificaton, etc.

Seems inconsistent that your goup can wirte "programs" using the sort and other utilities, but not use a real programming language. . . icon_confused.gif

Are you allowed to use Easytrieve?

As Dave suggests, SUPERCE may do what you want. If everything matches, the output will be ok, but if there are differences and you want to show additional detail. . . . icon_sad.gif
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 5 Thu Apr 27, 2017 1:15 am
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm


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