Answer Posted / pasha

always 18 only

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

614

---

Which is faster delete or truncate?

679

---

How to retrieve rows from a db2 table in embedded sql?

729

---

What is the difference between cursor and select statement?

615

---

Define data page.

634

---

---

What is bind in db2?

604

---

What is a collection in db2?

580

---

What is dclgen (declaration generator)?

603

---

What does runstats do in db2?

607

---

What is the max length of sqlca?

764

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

719

---

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

632

---

How connect db2 database to datastage?

763

---

What does db2 stand for?

597

---

Why select is not preferred in embedded sql programs?

715

---