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.