Answer / ereshwari

Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock

What is PRIME TABLE and what are the uses of it

1 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

How do I delete a table in database?

0 Answers  

---

What information is contained in a SYSCOPY entry?

2 Answers  

---

What is package in cobol db2?

0 Answers  

---

What is a LIKE table and how is it created?

2 Answers  

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

Update command

1 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

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

5 Answers   CTS,

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---