What is the use of with ur in db2?

0 Answers  

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

What else is there in the PLAN apart from the access path?

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  

---

What is commit in db2?

0 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

What is the maximum length of sqlca?

0 Answers  

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---