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

[Moved]Transfer the particula table form production region to test


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
philipraju
Warnings : 1

New User


Joined: 16 Apr 2006
Posts: 29

PostPosted: Thu Jun 08, 2006 1:30 pm
Reply with quote

Hi to all,
i want to know how we will transfer the particula table form production region to test region or any some other region
Back to top
View user's profile Send private message
amitrath

New User


Joined: 30 Apr 2004
Posts: 28
Location: Carmel, USA.

PostPosted: Tue Jun 13, 2006 2:53 am
Reply with quote

R u asking about a DB2 table? If yes, here is a 2 step solution:

Step 1)
To export test region table into a flat file, open the table in QMF (select *), and run the command:-
export data to <flatfile.ds.name>
QMF will export the data on your screen to the flat file.

Step 2)
Import the flatfile into production table. Run the following command in QMF command line:

Import table xxxxxxxp.tablename from <flatfile.ds.name>


PS:- you have to specify tablename in step 2 only.
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 -> All Other Mainframe Topics

 


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 Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts How to 'Ping' a CICS region in JCL CICS 2
Search our Forums:

Back to Top