I have 2 files, in file1 record length is 81 and has good data(has log numbers too). File2 has record length 8 which only has log numbers. I want to select records from file1 based on the log numbers given in file2 into a third file. How can i do that through ICETOOL. I tried using SPLICE /SORT option of ICETOOL but nothing worked.
Please show an example of the records in each input file (relevant fields only) and what you expect for output. If input file1 can have duplicates within it, show that in your example. If input file2 can have duplicates within it, show that in your example. Give the RECFM and LRECL of each input file. Give the starting position, length and format of each relevant field.
No, swapping things like that wouldn't work. The job I gave you works as I coded it given what you told me about your input file. It copies the FB/6 file (no dups) to T1 and then the FB/46 file (dups) to T1. The records must be in that order in T1 for WITHALL to work. Notice I had IN2 as the FB/6 file and IN1 as the FB/46 file and copied IN2 before IN1.
In your job, you have IN1 as the FB/6 file and IN2 as the FB/46 file and you're copying IN2 and then IN1. That would put the FB/46 records before the FB/6 records which wouldn't work. If that did work, then either your input files or your JCL is not what you said it was.