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 database manager in db2?

0 Answers  

---

What is meant by union and union all?

0 Answers  

---

What are bind parameters in db2?

0 Answers  

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How to create backup table in db2?

0 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---