MVSFORUMS.com

RIA · Beginner Joined: 26 Feb 2004 Posts: 4 Topics: 1

If I am doing a compare between 1 to many records between 2 files and the one with many records is a VSAM file....how can I compare and merge the records together ?

How to use POINT statements in Easytrieve to get data from a VSAM file. Please help !
_________________
Thanks

RIA

kolusu · Posted: Mon Mar 01, 2004 2:25 pm Post subject:

Ria,

Read chapter 7 from the following link which will give you a detailed explanation and use of POINT statement along with examples.

Easytrieve Application Programming Guide

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

RIA · Beginner Joined: 26 Feb 2004 Posts: 4 Topics: 1

Kolusu,

I have already used that chapter and it did not help much. I have recently started using easytrieve and I do not understand how to do the compare because only one of the two files is VSAM and more so because the keys are different.

Can you please help with some easytrieve code ?
_________________
Thanks

RIA

kolusu · Posted: Thu Mar 04, 2004 12:45 pm Post subject:

Ria,

You need to post more details. Easytrieve does not have option of reading a vsam file with a partial key. post a sample input data and desired output data.

You can also try the solution suggested in here

http://www.mvsforums.com/helpboards/viewtopic.php?t=1915

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

RIA · Beginner Joined: 26 Feb 2004 Posts: 4 Topics: 1

Hi Kolusu,

Here is how my files look like, somewhat. Thanks for your help.
FILE 1

vijay · Beginner Joined: 09 May 2003 Posts: 131 Topics: 64

Hi Ria,
Use VSAM as the input file.Search the other file using POINT(if you know the partial key) or START (if you know the full key) or use a simple Table search if the file size is less and write the output file.

Vijay