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

CA Easytrieve compare


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

New User


Joined: 30 Apr 2008
Posts: 3
Location: Bangalore

PostPosted: Thu May 22, 2008 3:54 pm
Reply with quote

I have 2 files in easytrieve. I have to compare 2 fileds from both the fileds and need to write to output files. But in the first input file the fileds are.. alphanumeric. Eg:
I-DEP-NO 15 2 A
I-CLM-ID 43 14 A
and in the second input file these 2 fileds are..packed decimala nd binary..
eg:
DEP-NO 13 2 B
CLM-ID 15 6 P
Could you please suggest me how to compare these fields?

Deepthi
Back to top
View user's profile Send private message
HappySrinu

Active User


Joined: 22 Jan 2008
Posts: 194
Location: India

PostPosted: Thu May 22, 2008 4:12 pm
Reply with quote

did you search in this forum before..

try this link ,
may helpfull..http://www.jmit.com/os390/docs/CA/EZTP-62-UserGuide.pdf

i think you may get if you search in this forum then internet
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Thu May 22, 2008 4:59 pm
Reply with quote

Hi,
Declare working storage for each field as numeric
W-DEP-NO 2 N
W-CLM-ID 14 N
move that I-DEP-NO 15 2 A
I-CLM-ID 43 14 A to the working storage (i guess 15 43 is the starting position)in the same way do it for the second easytrieve.
now you can compare and write it to an output file.
Back to top
View user's profile Send private message
Deepthi Reddy

New User


Joined: 30 Apr 2008
Posts: 3
Location: Bangalore

PostPosted: Thu May 22, 2008 5:10 pm
Reply with quote

Thanks for you reply. But I have one more question. I need to compare the both input files with the dep-code and clim-id fields then have to write to third file. But the problem is when we open the input files (JOB INPUT stmt) that time need to give key fileds (comparing fileds). So I think we cannot move to them to the working storage fileds and compare.

Is there any other way pls let me know...

Deepthi.
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Thu May 22, 2008 5:51 pm
Reply with quote

Hi,
I am not getting you can you give me some more info on this because this easytrieve is written to compare and write to an output file is that correct?
Back to top
View user's profile Send private message
Deepthi Reddy

New User


Joined: 30 Apr 2008
Posts: 3
Location: Bangalore

PostPosted: Thu May 22, 2008 6:10 pm
Reply with quote

Hi,

Yes you are correct..

I got the idea for my question.. Thanks alot for ur help..




Thanks in Advance,
Deepthi
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 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Compare two files with a key and writ... SYNCSORT 3
No new posts Compare latest 2 rows of a table usin... DB2 1
Search our Forums:

Back to Top