Answer / Deepu Nayak

Binding in DB2 is the process of compiling database application programs or SQL statements. It helps to precompile SQL statements, creating a prepared statement or a procedure, which can improve the performance of your database application by reducing the amount of parsing and compilation that needs to be done at runtime.

What is scrollable cursor in db2?

1 Answers  

---

What is database reorganization?

1 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

When will you chose to run RUNSTATS?

1 Answers  

---

What is a recovery log?

1 Answers  

---

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

Explain in detail about buffer manager and its functionalities?

1 Answers  

---

Highlight all the advantages that are attached to a package.

1 Answers  

---

What does an outer join do?

1 Answers   CTS,

---

Which component is responsible for processing sql statements and selecting access paths?

1 Answers  

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1 Answers   MCN Solutions,

---