what is consistency token

3 Answers  

---

How is a typical DB2 batch program executed ?

1 Answers  

---

Can there be more than one cursor open for any program?

0 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

What is a db2 table?

0 Answers  

---

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

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  

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---