Joined: 28 Nov 2006 Posts: 305 Location: Deerfield IL
Is there an INFIL command like the OUTFIL, with INREC, INCLUDE and OMIT for multiple input files?
Currently I need separate job steps to reformat each input file into a common format and then another step to sort/process the reformated files concatenated together. If I could use INFIL with a separate INREC for each input file I could do this all in 1 step.
Douglas,
Please mention your requirements with more details, with its Input and expected output file structure.
Yes, I think the solution you are looking for can be acheived by Icetool but with more details it will be easier to provide the solution.
I have more than 2 input files but I use sort to reformat each each input file similar to this.
It would be nice if we could do this in one step instead of 3, with an INFIL with an INREC for each input file.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Oh, I see. Since the two input files have different LRECLs, you'd like to be able to use INFIL to reformat them for the sort/sum.
You can, of course, do this in one step with ICETOOL (COPY operator, COPY operator, ..., SORT operator). What I think you really want though is to be able to do it in one pass with INFIL and that function isn't available.