Answer / s

CS - page or row locks are released as soon as the cursor
is moved to another row or page.

RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

Define buffer pool.

0 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is meant by concurrency?

1 Answers  

---

What is a synonym ?

2 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

How do you insert a record with a nullable column?

2 Answers  

---