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  

---

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  

---

What is blu acceleration in db2?

0 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

---

What are foreign keys?

1 Answers  

---

How many databases are there?

0 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

What is rct?

0 Answers  

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

What is explain plan in db2?

0 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---