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

Compare each record from file A with all the records from


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srinivas_cog

New User


Joined: 05 Jun 2008
Posts: 17
Location: chennai

PostPosted: Mon Jun 23, 2008 6:10 pm
Reply with quote

Hi,

i want to compare each record from file A to all the records from file B, if not matched, want to write the details of the record from file A.

I want to write it in EAZYTRIEVE,Could you please suggest me.

Thanks
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: Mon Jun 23, 2008 10:19 pm
Reply with quote

Hello,

Do you have "keys" to match or are you trying to compare the entire record?

Please post an example of the data in your input files and what you want as output from that input.
Back to top
View user's profile Send private message
srinivas_cog

New User


Joined: 05 Jun 2008
Posts: 17
Location: chennai

PostPosted: Tue Jun 24, 2008 4:34 pm
Reply with quote

I have the ket to compare..

My requirement is :

fileA : KEY HCNNO
fileB : KEY HCNNO

I want to compare the files and if not matching i want to write the record from fileA.
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 Jun 24, 2008 7:23 pm
Reply with quote

Hello,

First sort both files by the "key".

Next, code a 2-file match/merge or use the matching capability of easytrieve (ther are multiple previous posts in the forum).

If you do not know how to write a 2-file match/merge, there is a "Sticky" near the top of the COBOL section of the forum that you can use as pseudo-code. Or, you can simply download the sample code and use it.
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Wed Jun 25, 2008 9:12 am
Reply with quote

hi

refer to this topic.
ibmmainframes.com/viewtopic.php?t=31335&highlight=
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jun 25, 2008 1:03 pm
Reply with quote

I would recommend using DFSORT for this, and the topic is well discussed in that forum with good examples too.
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 -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 2
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
Search our Forums:

Back to Top