How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is a trigger in the db2 database?

0 Answers  

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---

What is index cardinality?

3 Answers  

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

What is referential integrity?

5 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

What is the difference between static and dynamic SQL?

1 Answers  

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

What is a bind card?

0 Answers  

---

How can you classify the locks in db2?

0 Answers  

---