What is bind plan?

0 Answers  

---

What is phantom read in db2?

0 Answers  

---

Why cursor is used in db2?

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 static sql? what is dynamic sql? Give me details

3 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

What is the default page size of buffer pools?

0 Answers  

---

Explain about rct in db2?

0 Answers  

---

How to take backup of table in db2?

0 Answers  

---

When do you use the IMAGECOPY?

4 Answers  

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---