MVSFORUMS.com

kolusu · Posted: Thu Jan 09, 2003 11:04 am Post subject:

Vallabhaneni,

If your intention is to write out every matching occurance for a given key then you need to move the IF MATCH-FOUND EQUAL 'Y' logic within the perform loop.

vallabhaneni · Beginner Joined: 26 Dec 2002 Posts: 23 Topics: 7

Hi Kolusu

Thanks for the information.But If does not match in second field ,then also i have to write a record with first field match and second field does not match from occurs.

Thanks

Vallabhaneni

kolusu · Posted: Thu Jan 09, 2003 11:59 am Post subject:

vallabhaneni,

Please post a sample input data and expected output data, so that it will be easy for other people to intrepret as to what you are trying to do.

Thanks

Kolusu

vallabhaneni · Beginner Joined: 26 Dec 2002 Posts: 23 Topics: 7

Thanks Kolusu,

Input file 1
record 1
procedure code 11111
type of service 1
record 2
11112
trpeof serive 2

input file 2
record 1
procedure code 11111
type of service first occurs value 1
second occurs value 2
third 3
fourth 4
fifth 5

record 2
procedure code 11112
type of service first occurs 1
second 2
third 3
fourth4
fifth 5

i need one out put like if matches in first filed and second field
out put file 1
first record
procedure type of service
11111 1
second record
11112 2

if first field match in both records and second field doesnot match
then

output file 2
first record
procedure code type of service
11111 2
11111 3
11111 4
11111 5

second record

11112 1
11112 3
11112 4
11112 5

Sorry for the inconvience.
Thanks for you help

Vallabhaneni

kolusu · Posted: Thu Jan 09, 2003 2:07 pm Post subject:

vallabhaneni,

I had hard time reading your input data and finally after scratching a lil bit ,I was able to understand what you want to do.Try to post the input data as follows.

Input file: 1

vallabhaneni · Beginner Joined: 26 Dec 2002 Posts: 23 Topics: 7

Hi Kolusu,

Thank you your prompt replies.But I am getting only one record in matched one means first file.I am keep on working on this .If you get a chance pls look into the code.

Thanks
Vallabhaneni

kolusu · Posted: Thu Jan 09, 2003 5:18 pm Post subject:

Vallabhaneni,

You are setting the switch(MATCH-FOUND) to 'y' as soon as you find a match in any of the occurance. And you are checking for that switch to be 'y' in the perform varying statement.

So if the match is found the perform will end and come out of the loop. so make changes to
your perform statement to the following.I removed the switch totally.

vallabhaneni · Beginner Joined: 26 Dec 2002 Posts: 23 Topics: 7

Thank you very much Kolusu,

Thanks
Vallabhaneni