MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Scheduling UNLOAD and LOAD jobs

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
satyenderd
Beginner


Joined: 26 Aug 2005
Posts: 144
Topics: 73

PostPosted: Tue Aug 19, 2008 6:35 pm    Post subject: Scheduling UNLOAD and LOAD jobs Reply with quote

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
View user's profile Send private message
CraigG
Intermediate


Joined: 02 May 2007
Posts: 202
Topics: 0
Location: Viginia, USA

PostPosted: Wed Aug 20, 2008 6:56 am    Post subject: Reply with quote

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
View user's profile Send private message
satyenderd
Beginner


Joined: 26 Aug 2005
Posts: 144
Topics: 73

PostPosted: Wed Aug 27, 2008 4:25 pm    Post subject: Reply with quote

Thanks Craig.
_________________
Satya
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group