Answer / s

The dynamic SQL is prepared at run time and the access path
is determined at execution time. Dynamic SQL changes from
one execution to another.

Answer / kamalakar

At runtime when the PREPARE statement is issued.

What is Reorg Recovery? when will you run it?

2 Answers  

---

what is datacom db?

2 Answers   CSC,

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

Which components manage deadlocks in db2?

0 Answers  

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---