IBM MAINFRAME HELP & SUPPORT FORUMS

satyender · Joined: 05 Jan 2008 Posts: 40 Location: hyderabad

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.

dick scherrer · Joined: 23 Nov 2006 Posts: 8733 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.

satyender · Joined: 05 Jan 2008 Posts: 40 Location: hyderabad

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.

dick scherrer · Joined: 23 Nov 2006 Posts: 8733 Location: 221 B Baker St

You're welcome - good to hear it is working :)

Thank you for letting us know.

d