we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

Is db2 relational database?

0 Answers  

---

What is bind and rebind in db2?

0 Answers  

---

Highlight all the advantages that are attached to a package.

0 Answers  

---

---

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

Are view updateable?

0 Answers  

---

how can we find nth max salary from A table

5 Answers   IBM,

---

Is the primary key a clustered index?

0 Answers  

---

What is a page?

2 Answers  

---

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  

---