Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

Who uses db2?

0 Answers  

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

How to create backup table in db2?

0 Answers  

---

What are the Isolation levels possible ?

5 Answers  

---

Explain about cursor stability?

0 Answers  

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

What is subquery ?

6 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---