Answer / naveen87ginjupalli

SQLCODE, SQLERRM, SQLERRD.

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  

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

What do you mean by commit and rollback?

0 Answers  

---

What is the purpose of using commit?

0 Answers  

---

What is auditing?

2 Answers  

---

How to update more then one record using update?

5 Answers   IBM,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

What is explain plan in db2?

0 Answers  

---

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

---

what is utility for parm lib

0 Answers   IBM,

---