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

How to 'load' a image copy into another table?


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

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Tue Sep 18, 2012 7:30 pm
Reply with quote

I have two tables,let's say, TA, TB , which has the exactly the same structure.

Now , I have an image copy of TA,
and I want to 'load' the data of the image copy into TB.

other than the following methos, is there another faster way of doing this?

the method I can think of is:
step 1. UNLOAD from image copy of TA,
step 2. LOAD the result of step 1 into TB.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Tue Sep 18, 2012 7:33 pm
Reply with quote

Read up on DSN1COPY. Realize that the responsibility is entirely yours.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Tue Sep 18, 2012 7:35 pm
Reply with quote

To the best of my knowledge, that is the best way to do it.

There are other ways, but they usually involve some manipulations that are both risky and possibly unsupported.
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 Pulling a fixed number of records fro... DB2 2
No new posts How to load to DB2 with column level ... DB2 6
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top