Here is a sample file that uses a loop to create variables. Now I need to to store the created variables in a table, and clear or delete the variables after the table is created. Any help would be appreciated.
What I’m trying to do is assign multiple variables from a table, like what’s in my original file; so that’s the first part. The second part is when I have those 3 variables in a table, I want to use them in the scrip to alias fields. So I would end up a field1 as A, field2 as B, field3 as C. When the load stops, I want to have field names as 1, 2, 3 and then if possible I want to remove the variables A, B, C from the system.
This is just a test. What I’m really doing is working with an AS400 library, and I need to rename the fields is many tables.