U could probably go for a bulk insert also. try this option insert into

How to insert more than one record using insert?

Question Posted / ratheesh nellikal

U could probably go for a bulk insert also.
try this option

insert into schema.table1
select * from schema.table2;

Cheers,
Ratheesh Nellikal

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is ibm db2 used for?

1066

What is difference between rollback and commit?

1149

What are the prerogatives?

1071

Why cursor is used in db2?

1030

What is isolation level in db2?

994

What is phantom read in db2?

1145

What is the difference between drop table and delete table?

1201

What types of tables are there in the db2 database?

1048

What is load utility in db2?

1177

What is a storage group (stogroup)?

1241

What is database alias db2?

1116

What is the difference between nvl and coalesce?

1057

What is the use of db2 optimizer?

1101

What is database manager in db2?

1009

How to find the number of rows in db2 tables?

1054