Answer / sudhir kumar

With the help of restart checkpoint logic.

What is a view? Why use it?

3 Answers  

---

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

1 Answers   TCS,

---

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 node in db2?

0 Answers  

---

What is a DB2 access path?

1 Answers  

---

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

Discuss about db2 bind?

0 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

What is a collection in db2?

0 Answers  

---

Which components manage deadlocks in db2?

0 Answers  

---