i have one table called admin_master consisting of numbers of data....


another table called admin_master_old consisiitng of old data


now i want to add this old data to exisiitng table admin_master without the loss of current data ,since data is huge how can i transfer data ...?

is it possible with export /import command ?but there are chances i can loose my current data in admin_master....
and, in admin_master one column is genrated always ,so it will be difficult to transfer data .....

please tell me the solution if anyone here knows ..

thank you

you can use

import from <filename>.del of del insert_update into admin_master

kindly chk in test envi before doing in prod

regds
Paul

you could declare a cursor and execute load from cursor
see infocenter for detailed command : load from cursor

You may want to add a WHERE clause or use a cursor to iterate over the rows in chunks and do some intermediate commits. You should also specify the column lists so that you can handle the generated column, e.g. by omitting it.

You may find this article helpful:
A Primer on Moving Data In and Out of DB2 Tables Defined with Generated Columns

yes now its working

db2 cursor technique also working



thanks db2girl

the link contains nice info...