What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

How do I add a column to a table in db2?

0 Answers  

---

how 2 resolve the -311 sqlcode

1 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  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

---

What is dclgen (declaration generator)?

0 Answers  

---

What does db2 blu stand for?

0 Answers  

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

What does db2 mean?

0 Answers  

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

Explain about cursor stability?

0 Answers  

---

Can you use max on a char column?

0 Answers  

---