What are PACKAGES ?

3 Answers  

---

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  

---

What are the disadvantages of PAGE level lock?

3 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,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

What is concurrency in db2?

1 Answers  

---

How will you return the number of records in table?

0 Answers  

---

Which isolation level provides maximum concurrency?

0 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---