Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Compare each record from file A with all the records from

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
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    Post subject: Compare each record from file A with all the records from
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

Site Director


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

PostPosted: Mon Jun 23, 2008 10:19 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Tue Jun 24, 2008 7:23 pm    Post subject:
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    Post subject:
Reply with quote

hi

refer to this topic.
http://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: 8657
Location: Back in jolly old England

PostPosted: Wed Jun 25, 2008 1:03 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 Tue Apr 17, 2018 10:42 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm
No new posts converting a mainframe file with ASA ... Lynne Schuler All Other Mainframe Topics 5 Wed Apr 04, 2018 9:44 am
No new posts Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us