View previous topic :: View next topic |
Author |
Message |
satyenderd Beginner
Joined: 26 Aug 2005 Posts: 144 Topics: 73
|
Posted: Tue Aug 19, 2008 6:35 pm Post subject: Scheduling UNLOAD and LOAD jobs |
|
|
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.
_________________ _________________ Satya |
|
Back to top |
|
 |
CraigG Intermediate
Joined: 02 May 2007 Posts: 202 Topics: 0 Location: Viginia, USA
|
Posted: Wed Aug 20, 2008 6:56 am Post subject: |
|
|
If the unload is the same sub-queries everytime then just save the altered syspunch cards and use the same (altered) ones everytime for the load. |
|
Back to top |
|
 |
satyenderd Beginner
Joined: 26 Aug 2005 Posts: 144 Topics: 73
|
Posted: Wed Aug 27, 2008 4:25 pm Post subject: |
|
|
Thanks Craig. _________________ Satya |
|
Back to top |
|
 |
|
|