IN BDE versions prior to 5. 0, The BDE connection to DB2 and ODBC do not support prepare. Performing a prepare causes a no-op to occur.

BDE 5. 0 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.