VSAM and Sort

visakhchandran · New User Joined: 29 Aug 2006 Posts: 1

I need a sort solution for the following issue.

I have a VSAM file that contain following data First 7 bytes is the key field, 8th byte is an indicator fiels and 9th field Match indicator field.

&

An Input file having key field ( From 24th position 7 bytes long )and of length (LRECL of the input file ) 5500.

I want to read the first record in my input file, from which the key field is taken and corresponding key field is being searched in the Vsam file and if there is a hit i want to write the input file into it Outfile1 after updating the Match indicator field in Vsam to Y . If there is no hit i want to write that corresponding file to Outfile2. Therefore i want to check for all the input files.

expat · Posted: Wed Aug 08, 2007 6:01 pm

This, or a very similar question was asked a while ago, and I gave a solution in REXX to do this.

Please use the search facility to look around for my solution. I'm currently too busy to look for you.

Frank Yaeger · Posted: Wed Aug 08, 2007 8:02 pm

visakhchandran,

Please show an example of the records in each input file and the records you expect in each output file.

dick scherrer · Posted: Thu Aug 09, 2007 1:30 am

Hello,

Just confirming i've understood the requirement.

Keys that match cause data to be written to outfile1.

Keys that do not match cause data to be written to outfile2.

Each time data is written to outfile1, the "match indicator" in the record in the existing VSAM file is to be updated.

Please let me know if i've misunderstood.