Extracting N number of records based on particular value

ranjanp · New User Joined: 02 May 2006 Posts: 25

Hi All,

I tried searching the forums for this but was unable to find the solution. I apologize, if this topic has already been discussed and I was not able to find it.

I have a file with first name starting from column 10 till 35.

I have 1000000 records in it.

I also have a subset of 100 members (first name).

Is there a way I can extract these 100 members using a JCL, I do not want to put all the 100 FIRST NAMES in INCLUDE condition.

dick scherrer · Posted: Thu Jan 22, 2009 6:50 am

Hello,

Which sort product is used on your system?

Do you have Easytrieve?

One way to do what you want is to sort both files by first name (making a copy of one or both if the original sequence needs to be preserved) and then "matching" the 2 files writing the "hits" to a file of only the 100 names you want.

dick scherrer · Posted: Thu Jan 22, 2009 6:52 am

To continue -

If this is a one-time requirement and the 100 names are already in a file, it would be easy to create the INCLUDEs with the editor. . .

lohithegde · New User Joined: 18 May 2008 Posts: 31 Location: Chennai

Hi Ran

I am unable to understand your req

Arun Raj · Posted: Thu Jan 22, 2009 9:30 am

ranjanp,

If you have SyncSort for z/OS Release 1.2 or higher, I think you can easily do this using a SyncSort JOIN application to extract the matching records.

As asked above, please mention the sort product used in your shop- DFSORT or SyncSort. Also the input LRECL/RECFM.