Answer / s

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

What is a view? Why use it?

2 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

Is db2 a mainframe?

0 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

What are host variables in db2?

0 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

where will u check for sqlcode ?

2 Answers   TCS,

---