I have two input files to be compared (RECFM=FB, LRECL=80) and need to write matched records from FILE-2 to output.
File-1: Key field 1 to 6
----+----1----+----2----+----3----+----4----+
XMTR51 TG1SE51XXAS106591 NOT A VALID ORDER
YMVSF2 TG1SE51XXAS110365 NOT A VALID ORDER
ZPBDN3 TG1SE51XXAS110379 NOT A VALID ORDER
XMTR51 TG1SE51XXAS106591 NOT A VALID ORDER
YMVSF2 TG1SE51XXAS110365 NOT A VALID ORDER
ZPBDN3 TG1SE51XXAS110379 NOT A VALID ORDER
File-2: Key field 21 to 26
----+----1----+----2----+----3----+----4----+
1TZA9 232 XMTR51
0SVJ9 232 YMVSZ2
0SVJ9 232 ZPBDN3
1TZA9 232 XMTR51
0SVJ9 232 YMVSZ2
0SVJ9 232 ZPBDN3
Required Output:
1TZA9 232 XMTR51
0SVJ9 232 ZPBDN3
0SVJ9 232 ZPBDN3
I have achieved it using JOINKEYS feature of Syncsort. Is it possible to achieve it using SPLICE or SELECT (Synctool) features too?
Thanks.