How will fetch last 5 rows from table in db2

6 Answers  

---

Which catalog tables contain authorization information?

1 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

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  

---

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

0 Answers  

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

What is dbrm? What it contains?

0 Answers  

---

Explain the EXPLAIN statement?

1 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is precompiler in db2?

0 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---