This us another post that came from a question I was asked by a reader of this blog. The question is:
I have multiple files in an IFS folder with similar names, each has a timestamp at the end of the file name to make them unique. How can I read all the files and write the contents into one file?
Fortunately there are two SQL Table Functions that can help me do this:
IFS_OBJECT_STATISTICS: To make a list of the files
IFS_READ: Read the contents of the files
The rest is pretty straightforward SQL and RPG.
Read more » Read More