How to select records from multiple files

Balaji C · New User Joined: 09 Apr 2015 Posts: 4 Location: India

Im a tester using File-Aid to select some records from a file. Now my requirement is to select the records based on field1 from File1 and another field2 in File2. Account number field is common in both the files.

Is there any way to filter my data like above?

Bill Woodger · Posted: Fri Apr 10, 2015 3:31 pm

Does the File-Aid documentation give you any clues or pointers? Your colleagues?

Easy task for SORT with JOINKEYS.

Balaji C · New User Joined: 09 Apr 2015 Posts: 4 Location: India

Thanks Woodger!

My colleagues dont have knowledge on mainframe. I dont have much expertise on join keys. Could you please explain me how to select some accounts based on Feild1=51 from File1 and Field2=1 thru 4 from File2. DDn1 and DDn2 are the DD names respectively

Control statements will be more helpful

rinsio · Posted: Fri Apr 10, 2015 6:09 pm

Hello Balaji,
I understand that position of Field1 start at 51.

Your control statements could be like this:

//JOINK2 EXEC PGM=SORT,COND=(0,NE)
//SYSOUT DD SYSOUT=*
//IN1 DD DSN=DDN1,
// DISP=SHR
//IN2 DD DSN=DDN2,
// DISP=SHR
//SORTOUT DD DSN=DDOUT,
// SPACE=(CYL,(40,20),RLSE),
// DISP=(,CATLG,DELETE)
//SYSIN DD *
JOINKEYS F1=IN1,FIELDS=(51,4,A)
JOINKEYS F2=IN2,FIELDS=(01,4,A)
REFORMAT FIELDS=(F1:1,LENGTHDDN1,F2:1,LENGTHDDN2)

OPTION COPY
/*

In the REFORMAT FIELDS command you can build the output file format. In the example tha output file contains both records.

Good luck
Regards

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

Balaji,

It's very disappointing that you didn't even try to Google and search for JOINKEYS when Bill suggested and you directly asked for the Control statements itself.

It wouldn't have taken more than 15 mins to do all what you wanted.

From the next time, please Google, Try, Fail and then ask others for help.

.

Balaji C · New User Joined: 09 Apr 2015 Posts: 4 Location: India

Balaji C · New User Joined: 09 Apr 2015 Posts: 4 Location: India