What is a Database Request Module(DBRM)?

4 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

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 do you do to keep the cursor from closing after a commit?

1 Answers  

---

What happens in bind step in a db2 program?

0 Answers  

---

When would you prefer to use VARCHAR?

3 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

What are iseries servers?

0 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

What do you mean by storage group (stogroup)?

0 Answers  

---