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  

---

What is commit in db2?

0 Answers  

---

What types of tables are there in the db2 database?

0 Answers  

---

What are foreign keys?

1 Answers  

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,

---

What information is used as input to the bind process?

2 Answers  

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  

---

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

2 Answers   Tech Mahindra, Wipro,

---