IBM Mainframe Forum

by **chuckb** » Fri May 06, 2011 12:16 am

I'm fairly new to Synctool. I am attempting to compare a field in one record to a field in another record and when they match, pull a third field from one of the records. Sample data:

Record 1: Field_A Field_B Field_C
Record 2: Field_X Field_A

When Field_A matches, pull Field_C and output to new file: FIeld_X Field_A Field_C

Your assistance is appreciated.

by **Alissa Margulies** » Fri May 06, 2011 12:23 am

Here is a sample SyncSort for z/OS job that will produce the requested output:

Select all

//SORT1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTOUT DD SYSOUT=*
//SORTJNF1 DD *
FIELD_A FIELD_B FIELD_C
//SORTJNF2 DD *
FIELD_X FIELD_A
//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(1,7,A)
JOINKEYS FILES=F2,FIELDS=(9,7,A)
REFORMAT FIELDS=(F2:1,16,F1:17,7)
SORT FIELDS=COPY
/*

by **chuckb** » Fri May 06, 2011 2:22 am

Thanks!

IBM Mainframe Forum

Match 2 Fields To Extract A 3rd Field

Match 2 Fields To Extract A 3rd Field

Re: Match 2 Fields To Extract A 3rd Field

Re: Match 2 Fields To Extract A 3rd Field