Prepared Execution
Prepared Execution is intended for statements that must be executed more than once. The execution of the statement is separated into two steps: SQLPrepare and SQLExecute. The SQLPrepare logic will create the access plan for the statement, while the SQLExecute logic will execute the statement.
Prepared execution has the advantage that the access plan will only be created once, while the statement can be executed multiple times. Creating an access plan is usually an expensive operation.
For Prepared Execution, the Embedded SQL interface defines SQLPrepare and SQLExecute.