Answer 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

Explain various types of locks in db2?

1098

---

How to run db2 command in windows?

1156

---

What does reorg do in db2?

996

---

What is the connection string to connect to the DB2 Database ?

1076

---

What is a db2 schema?

1189

---

Is it possible using max on a char column?

1098

---

What is dbrm in db2 database?

1052

---

If I have a view which is a join of two or more tables, can this view be updateable?

1096

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1046

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1051

---

What are the contents of a dclmgen?

1082

---

Explain the function of data manager.

1003

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2023

---

What is commit in db2?

1004

---

How do I import a csv file into db2?

948

---