• Basic Application Steps

BASIC APPLICATION STEPS

To interact with a data source, a simple application:

Connects to the data source. It specifies the data source name and any additional information needed to complete the connection.

Processes one or more SQL statements:

The application places the SQL text string in a buffer. If the statement includes parameter markers, it sets the parameter values.

If the statement returns a result set, the application assigns a cursor name for the statement or allows the driver to do so.

The application submits the statement for prepared or immediate execution.

If the statement creates a result set, the application can inquire about the attributes of the result set, such as the number of columns and the name and type of a specific column. It assigns storage for each column in the result set and fetches the results.

If the statement causes an error, the application retrieves error information from the driver and takes appropriate action.

Ends each transaction by committing it or rolling it back.

Terminates the connection when it has finished interacting with the data source.