Append data from another file

Abdul Lateef · New User Joined: 08 Sep 2011 Posts: 5 Location: india

Hi,

I want to append record from another file using sort in JCL.

My input files contain record as below.
Input file 1:
AAAA
BBBB
CCCC

Input file 2: (contains only 1 record which I want to append at the end of input file1 records )
2015-13-04

output file :
AAAA2015-13-04
BBBB2015-13-04
CCCC2015-13-04

Could anyone please help me on this.

Thanks,
Lateef

Pandora-Box · Posted: Mon Apr 13, 2015 4:10 pm

You could acheive this by using SYMNAMES

Lot of examples here

Abdul Lateef · New User Joined: 08 Sep 2011 Posts: 5 Location: india

Yes I got it through SYMNAMES.
Thank you so much.

Lateef

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

I thought JOINKEYS would work. Although he doesn't have any but he could use space as a key as there is only a single record in file2. That would work.

.

Bill Woodger · Posted: Mon Apr 13, 2015 6:35 pm

The symbols/SYMNAMES use for this is a two-step approach. Step 1, from the single-record file, create the symbol. Step two, put the generated file on SYMNAMES DD, and use the symbol.

Another approach is to generate the control cards.

With JOINKEYS, it will work, but higher resource use.