Selective records selection

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

Hi

The input file has user and his bus route no details as follows.

USER1 Route1
USER2 Route2
USER3 Route3
USER4 Route5

theres another input file which has only valid route nos. Say there are 2 lakh records in this file

Route1
Route2
Route5
Route9

In my output i want only the records from first file which have valid route nos. Can this be achieved using SPLICE , keeping in view that 2nd file has 2 lakh valid route nos.though we can use INCLUDE COND , but as there are many records in 2nd file is it possible to use SPLICE or any other option.

hence o/p would be

USER1 Route1
USER2 Route2
USER4 Route5

Frank Yaeger · Posted: Mon Apr 27, 2009 9:17 pm

What is the RECFM and LRECL of each input file?

Can there be duplicate users in file1?

Can there be duplicate routes in file2?

What is the starting position, length and format of the fields in each input file?

Terry Heinze · Posted: Tue Apr 28, 2009 3:28 am

For conformity to a standard, please use the Western numbering system instead of lakh.

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

File 1 will have duplicate route nos.For e.g.

USER1 Route1
USER2 Route2
USER3 Route3
USER4 Route5
USER5 Route3

File 2 has only unique valid route nos.

Both files are FB , Rec length is 80. For File 1 the first field is user name , it's of length 15 , then route nos which starts from 16th position and is of length 20 , then there are other data till 80th pos.

For File 2 , there's only 1 field. It starts from 1 and is of length 20.

Frank Yaeger · Posted: Tue Apr 28, 2009 8:32 pm

Assuming you want the output records sorted by the user name field, here's a DFSORT job that will do what you asked for.

Skolusu · Posted: Tue Apr 28, 2009 9:51 pm

Here is another way of getting the desired results using the new WHEN=GROUP function

Concatenate your both input files , but have the file2 (which just has the unq route numbers) first in the list.

Since the file2 has all spaces from pos 21 we use that as the indicator for a group.

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

Thanks , both the JCL's worked .