IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Scheduling UNLOAD and LOAD jobs


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Wed Aug 20, 2008 3:14 am
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.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Aug 20, 2008 4:57 am
Reply with quote

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.
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Thu Aug 21, 2008 3:02 am
Reply with quote

Thanks dick scherrer.

I have changed the DISP parameters and submitted the jcl and now it is working fine.

Thanks once again for your response.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Aug 21, 2008 3:28 am
Reply with quote

You're welcome - good to hear it is working icon_smile.gif

Thank you for letting us know.

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts Remote Unload of CLOB Columns DB2 6
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top