IBM Mainframe Forum

Hi,

I have 2 files. File F1 contains the account number range and File F2 contains the list of account numbers. If the account numbers in File F2 falls under the account range defined in F1, then those account numbers from F2 should be written into output

Contents of F1 - will contain only 1 record



Contents of File F2



Since account A105, A299 and A351 falls under the range, it should be written out to output



Can you please guide me in how to get this accomplished using Syncsort or SORT

Thanks
Sikkandhar

You will need two steps ...
the first step will read file 1 to generate the sort control statements
the second step will process file 2 using the control statements generated by the first step

You will find quite a few examples searching
here ==> http://www.ibmmainframeforum.com
but more here ==> http://ibmmainframes.com