If you want more than one database connection in your application, you can either use multiple SQLCAs or you can use a single SQLCA to manage the connections.
To use multiple SQLCAs Managing multiple SQLCAsEach SQLCA used in your program must be initialized with a call to db_init and cleaned up at the end with a call to db_fini.
See db_init method.
The embedded SQL statement SET SQLCA is used to tell the SQL preprocessor to use a specific SQLCA for database requests. Usually, a statement such as the following is used at the top of your program or in a header file to 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. It changes the state within the preprocessor so that any reference to the SQLCA will use the given string.
For more information about creating SQLCAs, see SET SQLCA statement [ESQL].
To use a single SQLCA |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |