FileAid move data from two files to one output file

kris_madras · New User Joined: 04 Jul 2005 Posts: 50

Hi,

I have data in two input files and I wanted to move to one output file with data from two files. Is this possible in fileaid batch? I have more input files to join.

Input1
-------------
USA

Input2
--------------
Wilmington, Delaware

Output
---------------
Wilmington, Delaware, USA

Joerg.Findeisen · Posted: Thu Feb 26, 2026 8:55 pm

STFW suggests a MERGE operation. But I seem unable to test this in our environment.

Joerg.Findeisen · Posted: Fri Feb 27, 2026 6:24 pm

To add, you can do the same with ICETOOL/SYNCTOOL, and are more portable.

sergeyken · Posted: Fri Feb 27, 2026 9:00 pm

Two input files, one single record each of them???!!!

kris_madras · New User Joined: 04 Jul 2005 Posts: 50

Yes two input files and one output file. The problem is two input files LRECLs are different. So I can't use them in SORTIN DD statement.
Our workshop has SYNCSORT and not ok to use SYNCTOOL in production runs.
I checked the document, INPFIL allows multiples input files but OUTPUT files will be created for each of them. Unlike IBM DFSORT, hard to find good examples in SYNCSORT documentation.

sergeyken · Posted: Mon Mar 02, 2026 7:14 pm

Use extra control statements under
//JNF1CNTL DD *
INREC BUILD=(...)
//*
and
//JNF2CNTL DD *
INREC BUILD=(...)
//*
to make both files attributes equivalent before joining them in main control statements under //SYSIN DD *
JOINKEYS F1=...
JOINKEYS F2=...
. . . . . . .
//*

P.S.
When using JOIN option there is no need for input files to have equal file attributes!!!

P.P.S.
SYNCTOOL is only simple interface between JCL and real SYNCSORT.
All processing is being performed by exactly the same SYNCSORT.
Prohibiting its use in production only reveals lack of education of management staff.