I'm posting this question again since I didn't get any response previously and am up against the wall for a solution.
I need to create an external, fixed length text file containing both a header and footer. All 3 files must conform to a fixed file format (starting location, ending location and length)
I have 3 tables with the necessary info to accomplish this from which I create 3 seperate text files.
Creating the files is not my problem. Appending (inserting) the header and footer files into the main file is.
If anyone could share the correct syntax to do this it will be greatly appreciated.
Of course, if anyone has a better idea of how to do this I welcome that input as well.