Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere ODBC API

 

Executing SQL statements

ODBC includes several functions for executing SQL statements:

  • Direct execution   SQL Anywhere parses the SQL statement, prepares an access plan, and executes the statement. Parsing and access plan preparation are called preparing the statement.

  • Prepared execution   The statement preparation is carried out separately from the execution. For statements that are to be executed repeatedly, this avoids repeated preparation and so improves performance.

    For more information, see Executing prepared statements.


Executing statements directly
Executing statements with bound parameters
Executing prepared statements