I am using SYNCSORT.
Header record(row) contains title and the remaining are data
Header--> EmpNo Dept Salary
Data-----> 1234 Payroll 10000
2345 HR 5000
File2 also has the same format;I want header(or first record in the file) to be removed from all the input files and merge data alone from them.
I can use OMIT function having some part of header label but i guess it will not be generic because almost 5-6 files are to be merged which will have same data content but Header text can vary for each file.Moreover new files can be added.
I am trying to find whether there is any generic part of code which will move first record from each of the input file used irrespective of what is the content in it.
I am explaining you the same scenario in another way,
Assume 10 files are sorted and merged into single file of same LREC using SYNCSORT.
My requirement is to remove the first record in each of the 10 files and create a sorted output irrespective of what data or type of data present in the first record.
These kind of topics have been debated to death.
I will be very much glad if you get me one link with solution similar to my requirement usng SORT .