Answer / ms. stanley

DCLGEN, as it is called, Contains the table Description and
the Field Names for the program to access the DB2 table

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

0 Answers  

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

how can u understand the end of the table ?

1 Answers   TCS,

---

Explain in brief how does db2 determine what lock-size to use?

0 Answers  

---

What is a clustering index ?

3 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

What is a cursor?

2 Answers  

---

What is dbrm in db2 database?

0 Answers  

---

difference between group clause and order clause

1 Answers  

---