Answer / s

You can use LOCK TABLE on any table. View is not a
physical object.

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

When would you prefer to use VARCHAR?

3 Answers  

---

What is difference between rollback and commit?

0 Answers  

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

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

1 Answers   TCS,

---

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

Is db2 relational database?

0 Answers  

---

define clustering index.

0 Answers  

---

Give the name of some fields form sqlca.

0 Answers  

---