Explain the contention situations caused by locks?

0 Answers  

---

What is DB2 (IBM Database 2)?

3 Answers  

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

What information is used as input to the bind process?

2 Answers  

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---