Question and Answer Database
FAQ4490B.txt — ODBC and DB2 don't do Prepare's
Category :Database (DB2)
Platform :32 bit Windows
Product : ALL 32 Bit BDE
Question:
How come I see no performance improvement when preparing
a query against an ODBC datasource or a DB2 datasource?
Answer:
IN BDE versions prior to 5.10, The BDE connection to DB2 and ODBC do
not support prepare. Performing a prepare causes a no-op to occur.
BDE 5.10 and later supports Prepare in a DB2 connection. However, executing two prepared statements in a row will generate a General SQL Error. To avoid getting the General SQL Error Unprepare after each SQL execution and then Prepare again before executing the statement again.
ODBC still does not support Prepare.
Last Modified: 01-MAR-00