How to handle null values in db2

4 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

What are the three lock types?

2 Answers  

---

What do you mean by cursor?

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 the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

What is an instance in db2?

0 Answers  

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

What do you mean by rollback?

0 Answers  

---

Is it possible using max on a char column?

0 Answers  

---

What are types of indexes?

0 Answers  

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---