What is declare cursor?

0 Answers  

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

Name the different types of Table spaces.

5 Answers   IBM,

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

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  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---