It's not clear what you want to do. Please show an example of the records in the input file (with sample values for all cols) and the expected output. Please explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of all relevant fields.
I got the below tool message when I use this sort card.
ICE600I 0 DFSORT ICETOOL UTILITY RUN STARTED
ICE650I 0 VISIT http://www.ibm.com/storage/dfsort FOR ICETOOL PAPERS, EXAMPLES A
ICE632I 0 SOURCE FOR ICETOOL STATEMENTS: TOOLIN
ICE630I 0 MODE IN EFFECT: STOP
SPLICE FROM(IN1) TO(BOTH) ON(1,3,CH) WITH(9,3)
ICE627I 0 DFSORT CALL 0001 FOR SORT FROM IN1 TO BOTH COMPLETED
ICE628I 0 RECORD COUNT: 000000000000007
ICE638I 0 NUMBER OF RECORDS RESULTING FROM CRITERIA: 000000000000002
ICE602I 0 OPERATION RETURN CODE: 00
If this is the case then just swap the files in the DD statement for IN1 like this
//IN1 DD File-2
// DD File-1
But that is not the req as per the statement by muralirajansm,
I need to get the corresponding col3 value from fileB for the records(2recs) in filea.
mkk157: And one more thing if you observe in muralirajansm's example
Reca3 is present in both File-1 and File2, but Reca5 is not found in File2 but is in File-1. To solve this i have the below ICETOOL solution