What are the contents of a DCLGEN?

4 Answers   MetLife,

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

What is image copy in db2?

0 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

How many types of page locks can be held in db2?

0 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

What is the maximum size of a char data type in db2?

0 Answers  

---

What is ALTER ?

3 Answers  

---

What are the disadvantages of using VARCHAR?

3 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  

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

What is package in cobol db2?

0 Answers  

---