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  

---

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 COPY PENDING status?

6 Answers  

---

What is collection in db2 bind?

0 Answers  

---

How to rename a table in DB2 ?

0 Answers   MCN Solutions,

---

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

What is nvl in db2?

0 Answers  

---

what are extents?

5 Answers  

---

What is bind and rebind in db2?

0 Answers  

---

What is the FREE command?

1 Answers  

---

What are the benefits of using the db2 database?

0 Answers  

---

Describe major components of db2?

0 Answers  

---