what is the name of the default db2 catalog database?

3 Answers   IBM,

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

How would the varchar column remarks defined?

0 Answers  

---

What is buffer pool?

0 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

What is commit in db2?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

How to resolve deadlock issue

5 Answers   IBM,

---