My requirement is I have to check the values present in Field2 of File1
is present in Field2 of FIle2. If not found then check whether the value in Field2 of File1 is present in the Field2 of File3.If it is not found write those records from FILE1 into a file.
But the value present in the FIeld2 of FILE3 has range . we need to check the value from FILE1 lies in that range or not.
Coudl you please help me to accoplish this using DFSORT.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Based on the information you've given, I think this DFSORT/ICETOOL job will do what you asked for. I assumed File1 Field2 is in positions 7-12, File2 Field2 is in positions 11-16, File3 lowrange is in positions 11-16 and File3 uprange is in positions 20-25. You can change the positions as appropriate.
We are building conditions like this from the file2 input records:
Code:
7,6,EQ,C'variable',OR,
3X -> three blanks
C'7,6,EQ,C''', -> 7,6,EQ,C'
Note that you must code two apostrophes for each apostrophe you want in the output record, so C'' = C'
11,6 -> positions 11-16 from the file2 input record (e.g. 444444)
C''',OR,', -> ',OR,
80:X - pads the records out with blanks to 80 characters