Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

How to check table size in db2 sap?

0 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

What is lock contention?

1 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

---

What is index in db2?

1 Answers  

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---