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 null indicator in db2?

0 Answers  

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---

How can you count the number of rows from a table tab?

0 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

When is the skeleton cursor table created?

1 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

What is meant by explain?

0 Answers  

---

What is buffer pool?

0 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---