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: 6966
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: 646
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm


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