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

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

2065

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1106

---

Define data page.

1068

---

What is buffer pool and list some of them?

1028

---

What are the uses of db2 optimizer?

1295

---

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

1081

---

What is lock escalation in db2?

1032

---

What is rebind in db2?

1061

---

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

1047

---

What is temporal table in db2?

1040

---

What is the use of value function?

1150

---

List out the data types available.

1153

---

What is explain plan in db2?

995

---

How to find the number of rows in db2 tables?

1072

---

What are union and union all?

982

---