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

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

789

---

Explain about cursor stability?

781

---

How do we specify index to include or not during bind process.

1854

---

What is the difference between cursor stability and repeatable read isolation levels?

901

---

What is db2?

910

---

What is cursor in dbms?

818

---

What is the reason behind not using select * in embedded sql programs?

833

---

What is db2 command?

768

---

How to find primary key of a table in db2?

805

---

How do I add a column to an existing table in db2?

773

---

What is phantom read in db2?

819

---

What is a collection in db2?

767

---

Why cursor is used in db2?

760

---

Differentiate between cs and rr isolation levels? Where do you specify them?

817

---

How can you quickly find out the # of rows updated after an update statement?

788

---