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  

---

How do I delete a table in db2?

0 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

What is usage pointer in cobol?

3 Answers   IBM,

---

Which catalog tables contain authorization information?

1 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

What is dpf in db2?

0 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

List some fields from sqlca?

0 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---