I would like to list the content of a specific folder on a server (like Date, Time, File Size, File Name) and save the information in a file that can be read and populate an iSeries DB2 database. Has anybody done this? Thank you. BTM.
This can be done by manipulating the File List variable attributes. Just create your file list, then perform a ForEach across that File List. When looping through the file list, you can insert your file information into the DB2 (or any) table as desired.
The Attributes available to you are defined in the help text associated to the command:
Hope this helps!
Lead Solutions Consultant