how to copy a db2 table to another db2 table ?

litty · #1 (**permalink**) 05-19-04, 04:04

hi,
I need to copy the contents of one db2 table to another db2 table...can anyone help me with achieving this..?
thanks in advance,
litty

Tank · #2 (**permalink**) 05-19-04, 06:55

There are several opportunities, but it depends on
your operating system and version - please post these
and I will give you some options.

litty · #3 (**permalink**) 05-20-04, 00:15

ours is OS/390....actually I need to copy the contents of a DB2 table in production into another DB2 Table again in production i.e the same region...then I also need to append some additional data at the end of the DB2 table after the copied data. How do I do this using a DB2 utility...?

Marcus_A · #4 (**permalink**) 05-20-04, 02:09

The easiest way is to use the following SQL statement:

insert into tablea select ... from tableb

Check out the SQL reference manual for details.

You can use the LOAD utility with resume option to add data from a sequential dataset to the table.

grofaty · #5 (**permalink**) 05-20-04, 02:18

Hi litty,

Please also see: http://www.dbforums.com/t997890.html

Hope this helps,
Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech