cursor with hold explain ?

1 Answers   Verizon,

---

What is precompiler in db2?

0 Answers  

---

How do you define a correlated name?

1 Answers  

---

What is the syntax required for the creation of a cursor?

1 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 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 db2 catalog database?

0 Answers  

---

What is the database descriptor?

2 Answers  

---

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

What are types of indexes?

0 Answers  

---

Can you use max on a char column?

0 Answers  

---

Is schema the same as database?

0 Answers  

---