Answer / deepak dada

is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base

What is a composite index and how does it differ from a multiple index?

1 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

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,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---