View previous topic :: View next topic
|
Author |
Message |
vijayprabu
New User
Joined: 15 Dec 2005 Posts: 21
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
vijayprabu
New User
Joined: 15 Dec 2005 Posts: 21
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
vijayprabu
New User
Joined: 15 Dec 2005 Posts: 21
|
|
|
|
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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
What is wrong with SUPERCE?
This appears simple enough.
You can use CMPCOLM option if need be. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. . .
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. . . . |
|
Back to top |
|
|
|