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

Comparisions of two files with same copy book structure


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
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
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: 6966
Location: porcelain throne

PostPosted: Tue Jul 13, 2010 11:37 pm
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
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

Moderator Emeritus


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

PostPosted: Tue Jul 13, 2010 11:57 pm
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
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: 782
Location: Pennsylvania

PostPosted: Wed Jul 14, 2010 12:13 am
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

Moderator Emeritus


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

PostPosted: Wed Jul 14, 2010 12:19 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Replace a string in a VB file and cop... DFSORT/ICETOOL 2
No new posts Copy next subsquent records based on ... DFSORT/ICETOOL 5
No new posts How can I get Generation Nbr of GDG f... IBM Tools 1
No new posts Splitting a file into multiple files ... DFSORT/ICETOOL 7
No new posts Get Record count from multiple files ... SYNCSORT 6
Search our Forums:

Back to Top