I have a large table with information about files on an AS/400, I have the file name, desc and field names. I want to be able to create a new table at each change in file name, adn have the table name corespond to the file name. So I am looking for a way to automate this so I do not have to enter each table name and run a make table query. Is there some code I can use that will look for each change in table name and create a new table? I hope I did a good job of explaining what I am trying to do.
Thanks in advance for any help