I have a requirement to write multiple records to an output file based on the provided template and the input file. Fields from the input file would be written to the output file based on the template record.
How can this be achieved? I tried to achieve this with multiple logics - one is to repeat the template record to the number of records in the input file and join them. It didn't work as I didn't find any clue to do that. Input file count is expected to be in millions.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
based on the provided template and the input file
How can you expact anyone to help you when you've shown us only one possible template, and not explained the rules for what the template can look like and how it should be applied to the other file's records?
You need to do a much better job of explaining what you're trying to do and all the possible variations before anyone can help you.
now i realize that it does not have the 'dynamic nature' of finding and using a found datafield,
but, if file 1 just contained the data to be used as the overlay value,
something slick could be created to create a dynamic sysname from file 1,
and a search for last non-char (first space) for overlay start could be created.
but, then again, how many different file types would you want to append data?
inotherwords, minor change of control cards for different files.
sorry guys, it is friday night, been a loooooong week,
don't know when to shut-up.