I've created a new table.
I've unlodead the data using sub-queries.
I've loaded the data into the new table.
While loading the table I've editied the SYSPUNCH card with the new columns as per the table.
If I unload the data again, I think the SYSPUNCH card will get changed once again, and if I want to load the table I think I must edit the SYSPUNCH card again. If I am not wrong.
Can I now schedule the UNLOAD and LOAD utilities so that they can run every time without editing the edited SYSPUNCH card.
Joined: 23 Nov 2006 Posts: 8771 Location: 221 B Baker St
Hello,
I'm not sure i understand everything you've mentioned, but once you have the LOAD control statements defined, you could put the control statements in a pds member and use that for repeated loads with no manual editing.
The same could be used for the UNLOAD.
As i mentioned, there may be something i misunderstand.
