Using multiple SQLCAs to manage multiple database connections

Use the SET SQLCA embedded SQL statement to tell the SQL preprocessor to use a specific SQLCA for database requests.

Prerequisites

There are no prerequisites for this task.

Initialize Each SQLCA used in your program with a call to db_init.
At the top of your program or in a header file, set the SQLCA reference to point at task specific data:
EXEC SQL SET SQLCA 'task_data->sqlca';
This statement does not generate any code and does not affect performance.

Results

The state within the preprocessor changes so that any reference to the SQLCA uses the given string.

Next

Clean up resources when closing your application with a call to the db_fini method.