What is null value in db2?

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,

---

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

What is phantom read in db2?

0 Answers  

---

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

What is catalog database in db2?

0 Answers  

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What are the disadvantages of PAGE level lock?

3 Answers  

---

What is package in cobol db2?

0 Answers  

---