Using the IBM Informix ODBC Driver API

An application uses the IBM Informix ODBC Driver API to make a connection to a data source, send SQL statements to a data source, process result data dynamically, and terminate a connection. The driver enables your application to perform the following steps:

1. Connect to the data source.

   You can connect to the data source through a DSN connection, or you can use DSN-less connection strings. Specify the data-source name and any additional information needed to complete the connection.

2. Process one or more SQL statements:
   1. Place the SQL text string in a buffer. If the statement includes parameter markers, set the parameter values.
   2. If the statement returns a result set, either assign a cursor name for the statement or let the driver assign one.
   3. Either prepare the statement or submit it for immediate execution.
   4. If the statement creates a result set, you can inquire about the attributes of the result set, such as the number of columns and the name and type of a specific column. For each column in the result set, assign storage and fetch the results.
   5. If the statement causes an error, retrieve error information from the driver and take the appropriate action.
3. End any transaction by committing it or rolling it back.
4. Terminate the connection when the application finishes interacting with the data source.

Every IBM Informix ODBC Driver function name starts with the prefix SQL. Each function accepts one or more arguments. Arguments are defined as input (to the driver) or output (from the driver).

Figure 4 shows the basic function calls that an application makes even though an application generally calls other functions also.

Figure 4. Sample Listing of Function Calls That an IBM Informix ODBC Driver Application Makes