Answer / Sanjeev Kumar Sinha

Contention situations caused by locks in DB2 can occur when multiple transactions attempt to access or modify the same data concurrently. This can result in waits, deadlocks, and increased response times as transactions must wait for locks to be released before proceeding.

What is a collection?

3 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

Name some fields from SQLCA

1 Answers  

---

What is meant by repeatable read?

4 Answers  

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

Explain db2.

1 Answers  

---

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

1 Answers   MCN Solutions,

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

What do you need to do before you do EXPLAIN?

1 Answers  

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---