Answer Posted / hatam

A package contains control structures used to execute SQL
statements
A plan is
1- A list of package names
2- The bound form of SQL statements taken from one or more
DBRMs
package is executable and plan not

How do you find the maximum value in a column in db2?

1150

---

How do I add a column to a table in db2?

1155

---

How many databases can be created inside an instance in db2 ?

1084

---

How do you stop a db2 database in linux?

1051

---

What do you mean by cursor?

1029

---

What is host variable?

1109

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1133

---

What is bind and rebind in db2?

1186

---

What is the physical storage length of date data type?

1304

---

What is isolation level in db2?

1065

---

What is package in cobol db2?

1158

---

What is buffer pool and list some of them?

1090

---

What is the meaning concurrency in the db2 database?

1160

---

What are the various data types available in db2?

1142

---

Define data page.

1122

---