Answer / s

ALTER STOGROUP
ADD VOLUMES (VOL1)
REMOVE VLUMES (VOL2)

Next time when you do REORG, LOAD replace, RECOVER the
tablespaces will be defined in the new volume added.

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

What is DCLGEN ?

3 Answers  

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

What is a host variable?

3 Answers  

---

How to access db2 tables in mainframe?

0 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,

---

How can you count the number of rows from a table tab?

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  

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---