Need to get records from input file depnding upon two fields

mrdilipchand · New User Joined: 20 Feb 2007 Posts: 12 Location: banglore

I need to extract records from input vsam file into output file depending upon two fields.

If the values of two fields are different then we need to write into output file.

Regards,
Dilipchand.

bansal · New User Joined: 03 Jan 2007 Posts: 27 Location: Hyderabad

Hi Dilip,

You can easily do it by a sort card(SYSIN).

Use the include condition and match the values of both the fields, if they are different then only select that record for the output.

Like this

INCLUDE COND= (2,2,CH,NE,5,2,CH)

Assume first field is of 2 characters starting from 2nd bytes and second field starts from 5th position and it is also of 2 bytes.

So the above will select the your desired records and write those records into the output VSAM file.

Hope the above will help..