Answer / s

You do not want to define an index on such a small table
because, its an overhead to maintain the index and
tablespace scan will only result in 1 I/O.

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

What does db2 mean?

0 Answers  

---

Explain about dbrm.

0 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 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  

---

What is the database descriptor?

2 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---