JCL SORT - FILTER RECORDS WITH CRITERIA IN AN INPUT FILE

srinut123 · New User Joined: 11 Oct 2005 Posts: 62 Location: India

Hi,

I've below requirement, please advice if it can be accomplished by JCL SORT.

1) I've a B/L extraction file in the below format:

UBL TST1969852430F00227026XYZ COMPANY
UBL TST2868852431F00337026ABC COMPANY

Positions 9 thru 17 is B/L number

2) I've a B/L key file, which has required B/L numbers

Requirement:

I'd like to copy the records from B/L extraction file to output file for all the B/L numbers which are in the key file (file 2), rest should be ignored.

Please advice the steps.

Thanks & Regards,
Sri

Bill Woodger · Posted: Mon Apr 30, 2012 4:30 pm

You need to use JOINKEYS. There are many examples here if you search. Yours is very simple from what you have said.

srinut123 · New User Joined: 11 Oct 2005 Posts: 62 Location: India

Thanks for the quick response Bill. I tried JOINKEYS and it worked fine.