Answer Posted / ram

Bind Parameters are below...

Bind Package/Plan
Owner (Authorization ID)
Qualifier (qualifier name)
Member (member name)
Library (DBRM Pds name)
ACTION (ADD/REPLACE)
Explain (Yes/No)
Flag (I/W/E/C)
ISOLATION (RR/RS/CS/UR)
Release (Commit/Deallocate)
Validate(Run/Bind)
Acquire(Use/Allocate)

How can you count the number of rows from a table tab?

1096

---

What is scrollable cursor in db2?

1059

---

Explain about rct.

1093

---

How can you quickly find out the # of rows updated after an update statement?

1053

---

How many types of page locks can be held in db2?

1044

---

List down the types of triggers in the db2 database?

1036

---

What is a db2 schema?

1241

---

What is bind package and plan in db2?

1062

---

What are the uses of db2 optimizer?

1301

---

What is the syntax for FETCH in DB2 ?

1225

---

What is the maximum size of varchar data type in db2?

1139

---

Is db2 a database?

984

---

What is the use of value function?

1160

---

Discuss about db2 bind?

1105

---

What is db2 optimizer?

1256

---