SAP Sybase IQ Database API for C/C++

The SAP Sybase IQ C application programming interface (API) is a data access API for the C / C++ languages. The C API specification defines a set of functions, variables and conventions that provide a consistent database interface independent of the actual database being used. Using the SAP Sybase IQ C API, your C / C++ applications have direct access to SAP Sybase IQ database servers.

• sqlany_affected_rows( a_sqlany_stmt *) method
  Returns the number of rows affected by execution of the prepared statement.
• sqlany_bind_param( a_sqlany_stmt *, sacapi_u32 , a_sqlany_bind_param *) method
  Bind a user-supplied buffer as a parameter to the prepared statement.
• sqlany_cancel( a_sqlany_connection *) method
  Cancel an outstanding request on a connection.
• sqlany_clear_error( a_sqlany_connection *) method
  Clears the last stored error code.
• sqlany_client_version(char *, size_t) method
  Returns the current client version.
• sqlany_client_version_ex( a_sqlany_interface_context *, char *, size_t) method
  Returns the current client version.
• sqlany_commit( a_sqlany_connection *) method
  Commits the current transaction.
• sqlany_connect( a_sqlany_connection *, const char *) method
  Creates a connection to a SQL Anywhere database server using the supplied connection object and connection string.
• sqlany_describe_bind_param( a_sqlany_stmt *, sacapi_u32 , a_sqlany_bind_param *) method
  Describes the bind parameters of a prepared statement.
• sqlany_disconnect( a_sqlany_connection *) method
  Disconnects an already established SQL Anywhere connection.
• sqlany_error( a_sqlany_connection *, char *, size_t) method
  Retrieves the last error code and message stored in the connection object.
• sqlany_execute( a_sqlany_stmt *) method
  Executes a prepared statement.
• sqlany_execute_direct( a_sqlany_connection *, const char *) method
  Executes the SQL statement specified by the string argument and possibly returns a result set.
• sqlany_execute_immediate( a_sqlany_connection *, const char *) method
  Executes the supplied SQL statement immediately without returning a result set.
• sqlany_fetch_absolute( a_sqlany_stmt *, sacapi_i32 ) method
  Moves the current row in the result set to the row number specified and then fetches the data at that row.
• sqlany_fetch_next( a_sqlany_stmt *) method
  Returns the next row from the result set.
• sqlany_finalize_interface( SQLAnywhereInterface *) method
  Unloads the C API DLL library and resets the SQLAnywhereInterface structure.
• sqlany_fini() method
  Finalizes the interface.
• sqlany_fini_ex( a_sqlany_interface_context *) method
  Finalize the interface that was created using the specified context.
• sqlany_free_connection( a_sqlany_connection *) method
  Frees the resources associated with a connection object.
• sqlany_free_stmt( a_sqlany_stmt *) method
  Frees resources associated with a prepared statement object.
• sqlany_get_bind_param_info( a_sqlany_stmt *, sacapi_u32 , a_sqlany_bind_param_info *) method
  Retrieves information about the parameters that were bound using sqlany_bind_param().
• sqlany_get_column( a_sqlany_stmt *, sacapi_u32 , a_sqlany_data_value *) method
  Fills the supplied buffer with the value fetched for the specified column.
• sqlany_get_column_info( a_sqlany_stmt *, sacapi_u32 , a_sqlany_column_info *) method
  Retrieves column metadata information and fills the a_sqlany_column_info structure with information about the column.
• sqlany_get_data( a_sqlany_stmt *, sacapi_u32 , size_t, void *, size_t) method
  Retrieves the data fetched for the specified column into the supplied buffer memory.
• sqlany_get_data_info( a_sqlany_stmt *, sacapi_u32 , a_sqlany_data_info *) method
  Retrieves information about the data that was fetched by the last fetch operation.
• sqlany_get_next_result( a_sqlany_stmt *) method
  Advances to the next result set in a multiple result set query.
• sqlany_init(const char *, sacapi_u32 , sacapi_u32 *) method
  Initializes the interface.
• sqlany_init_ex(const char *, sacapi_u32 , sacapi_u32 *) method
  Initializes the interface using a context.
• sqlany_initialize_interface( SQLAnywhereInterface *, const char *) method
  Initializes the SQLAnywhereInterface object and loads the DLL dynamically.
• sqlany_make_connection(void *) method
  Creates a connection object based on a supplied DBLIB SQLCA pointer.
• sqlany_make_connection_ex( a_sqlany_interface_context *, void *) method
  Creates a connection object based on a supplied DBLIB SQLCA pointer and context.
• sqlany_new_connection(void) method
  Creates a connection object.
• sqlany_new_connection_ex( a_sqlany_interface_context *) method
  Creates a connection object using a context.
• sqlany_num_cols( a_sqlany_stmt *) method
  Returns number of columns in the result set.
• sqlany_num_params( a_sqlany_stmt *) method
  Returns the number of parameters expected for a prepared statement.
• sqlany_num_rows( a_sqlany_stmt *) method
  Returns the number of rows in the result set.
• sqlany_prepare( a_sqlany_connection *, const char *) method
  Prepares a supplied SQL string.
• sqlany_reset( a_sqlany_stmt *) method
  Resets a statement to its prepared state condition.
• sqlany_rollback( a_sqlany_connection *) method
  Rolls back the current transaction.
• sqlany_send_param_data( a_sqlany_stmt *, sacapi_u32 , char *, size_t) method
  Sends data as part of a bound parameter.
• sqlany_sqlstate( a_sqlany_connection *, char *, size_t) method
  Retrieves the current SQLSTATE.
• a_sqlany_data_direction() enumeration
  A data direction enumeration.
• a_sqlany_data_type() enumeration
  Specifies the data type being passed in or retrieved.
• a_sqlany_native_type() enumeration
  An enumeration of the native types of values as described by the server.
• SACAPI_ERROR_SIZE variable
  Returns the minimal error buffer size.
• SQLANY_API_VERSION_1 variable
  Defines to indicate the API versions.
• SQLANY_API_VERSION_2 variable
  Version 2 introduced the "_ex" functions and the ability to cancel requests.
• SQLAnywhereInterface structure
  The SQL Anywhere C API interface structure.
• a_sqlany_bind_param structure
  A bind parameter structure used to bind parameter and prepared statements.
• a_sqlany_bind_param_info structure
  Gets information about the currently bound parameters.
• a_sqlany_column_info structure
  Returns column metadata information.
• a_sqlany_data_info structure
  Returns metadata information about a column value in a result set.
• a_sqlany_data_value structure
  Returns a description of the attributes of a data value.