Explain the function of data manager.

0 Answers  

---

What is the physical storage length of timestamp data type?

0 Answers  

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What is the use of db2?

0 Answers  

---

What is runstats utility in db2?

0 Answers  

---

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

What is dbrm? What it contains? When it will be created?

0 Answers  

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What is a Cartesian product?

2 Answers  

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

What is referential integrity?

5 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  

---