what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

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?

0 Answers   HeadStrong,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

Explain in brief how does db2 determine what lock-size to use?

0 Answers  

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

What is correlation names?

1 Answers  

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

What is the size of a data page?

2 Answers   IBM,

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---