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)

Mention the definition of cobol in varchar field.

1178

---

What is a db2 package?

986

---

What is a db2 collection?

981

---

How to find the number of rows in a db2 table?

1062

---

What is db2 optimizer?

1177

---

Before you give the explain statement, what are the prerogatives?

968

---

What is isolation level in db2?

939

---

What db2 400?

1101

---

What is db2 plan table?

991

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2338

---

Are views updateable?

1066

---

How can we read records for specific member in CL? AND rpg?

643

---

What is the syntax for creating a table in the db2 database?

1055

---

Why select is not preferred in embedded sql programs?

1225

---

What is access path in db2?

923

---