SQL in Open Client Applications

This section provides a very brief introduction to using SQL in Open Client applications, with a particular focus on SAP Sybase IQ-specific issues.

For a complete description, see the Open Client documentation at http://www.sybase.com/products/databasemanagement/openserver.

• Open Client SQL Statement Execution
  You send SQL statements to a database server by including them in Client Library function calls. For example, the following pair of calls executes a DELETE statement:
• Open Client Prepared Statements
  The ct_dynamic function is used to manage prepared statements. This function takes a type parameter that describes the action you are taking.
• Open Client Cursor Management
  The ct_cursor function is used to manage cursors. This function takes a type parameter that describes the action you are taking.
• Open Client Result Sets
  Open Client handles result sets in a different way than some other SAP Sybase IQ interfaces.