What is the STOSPACE Utility used for?

1 Answers  

---

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  

---

Define declaration generator (dclgen).

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is correlated subquery?

1 Answers  

---

---

Which catalog table stores referential constraints?

1 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---

What do you mean by cursor?

0 Answers  

---

What db2 400?

0 Answers  

---

What is a synonym? How is it used?

2 Answers  

---

What is view db2?

0 Answers  

---

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

0 Answers  

---