Answer / s

The lock is held as long as the cursor is positioned on the
page or row. The lock is released once the cursor moves to
another page or row.

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  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How to update more then one record using update?

5 Answers   IBM,

---

List out the three types of page locks that can be held.

0 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

What is coalesce in db2?

0 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

What is correlation names?

1 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is dbrm? What it contains?

0 Answers  

---