Joined: 30 Apr 2004 Posts: 28 Location: Carmel, USA.
R u asking about a DB2 table? If yes, here is a 2 step solution:
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.
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.