What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

What type of database is db2?

0 Answers  

---

What is a predicate?

1 Answers  

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

What are the uses of db2 optimizer?

0 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,

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

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

3 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

What is the use of with ur in db2?

0 Answers  

---

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---