IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to select records from multiple files


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Balaji C

New User


Joined: 09 Apr 2015
Posts: 4
Location: India

PostPosted: Fri Apr 10, 2015 2:51 pm
Reply with quote

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?
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Fri Apr 10, 2015 3:31 pm
Reply with quote

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

Easy task for SORT with JOINKEYS.
Back to top
View user's profile Send private message
Balaji C

New User


Joined: 09 Apr 2015
Posts: 4
Location: India

PostPosted: Fri Apr 10, 2015 3:46 pm
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message
rinsio

New User


Joined: 16 Feb 2015
Posts: 13
Location: Madrid, Spain

PostPosted: Fri Apr 10, 2015 6:09 pm
Reply with quote

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
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Fri Apr 10, 2015 7:02 pm
Reply with quote

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.

.
Back to top
View user's profile Send private message
Balaji C

New User


Joined: 09 Apr 2015
Posts: 4
Location: India

PostPosted: Mon Apr 13, 2015 2:43 pm
Reply with quote

rinsio wrote:
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

Thank You very much Rinsio. I have applied your logic with some modicications from Google. Finally made what I required. Thanks Again.]
Back to top
View user's profile Send private message
Balaji C

New User


Joined: 09 Apr 2015
Posts: 4
Location: India

PostPosted: Mon Apr 13, 2015 2:45 pm
Reply with quote

RahulG31 wrote:
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.

.

Rahul, Thanks for your suggestion. I have applied above logic with some modifications from Google. Finally able to make it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Print report for each record from mul... CA Products 1
No new posts Get two files from one file with diff... DFSORT/ICETOOL 10
No new posts Add column to existing records using ... JCL & VSAM 2
This topic is locked: you cannot edit posts or make replies. I HAVE 2 INPUT FILES WITH SAME LAYOUT... COBOL Programming 6
No new posts Syncsort- Merging two records into on... SYNCSORT 3
Search our Forums:

Back to Top