OUTREC should be one col from file1 & another from file

advith001 · New User Joined: 16 Mar 2005 Posts: 23

I required to write the output record having 2 columns, one from first file say file1 and another from second file file2 by using JCL. not COBOL code.

file1 having fldA fldB fldC
file2 having fldD fldE

outfile should have fldB and fldE

Please help me on this request.

Frank Yaeger · Posted: Tue May 10, 2005 8:45 pm

You need to give more detail. What is the RECFM and LRECL of each input file? Does each input file have only one record or many records? If many records, then do you want to "join" the fields from record 1 of file1 with record 1 of file2, record 2 of file1 with record 2 of file2, etc, or do you want to "join" the fields on a common key? What is the position, length of format of each relevent field?

Showing an example of records with actual values for input file1 and input file2 and what you want the output records to look like would help clarify what you need.

priyesh.agrawal · Posted: Tue May 10, 2005 9:49 pm

Check out below link....& go to the bottom of the page for the heading Join fields from two files record-by-record

http://www-1.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst03.html

It seems almost same, what your query is for...

Regards,

Priyesh

Frank Yaeger · Posted: Tue May 10, 2005 10:26 pm

Priyesh,

The correct URL for that Smart DFSORT Trick for "Join fields from two files record-by-record" is:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst03.html#t01

The URL for the Smart DFSORT Trick "Join fields from two files on a key" is:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t3a

One of these tricks may indeed be what the poster needs, but more information would tell us for sure.

BTW, the URL for the complete list of Smart DFSORT Tricks is:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/index.html

advith001 · New User Joined: 16 Mar 2005 Posts: 23

Dear all,

thankx i got solution for my requirement.
I apologize for the confusion.

My requrement is

FILE1
FLDA1 FLDA2 FLDA3
101 NameA1 LOCA1
102 NameA2 LOCA2
103 NameA3 LOCA3
104 NameA4 LOCA4
105 NameA5 LOCA1
106 NameA6 LOCA2
107 NameA7 LOCA3
108 NameA8 LOCA4

FILE2
FLDB1 FLDB2
102 NameA2
103 NameA3
105 NameA5
107 NameA7
109 NameA9

OUTFILE
FLDO1 FLDO2
102 NameA2
103 NameA3
105 NameA5
107 NameA7

Thanks,
Anna.

ssowjanya · New User Joined: 29 Apr 2005 Posts: 13

Hi Advith,
Can u explain how u solved ur problem.
thank u

asridhar · New User Joined: 04 May 2005 Posts: 5 Location: Hyderabad

can you explain whats the complete jcl for this one