![SET OPTION statement [DBISQL]](arrow-left.gif){kind=icon}
Tells the SQL preprocessor to use a SQLCA other than the default global sqlca.
SET SQLCA sqlca
identifier or string
The owing function could be found in a Windows DLL. Each application that uses the DLL has its own SQLCA.
an_sql_code FAR PASCAL ExecuteSQL( an_application *app, char *com )
{
EXEC SQL BEGIN DECLARE SECTION;
char *sqlcommand;
EXEC SQL END DECLARE SECTION;
EXEC SQL SET SQLCA "&app->.sqlca";
sqlcommand = com;
EXEC SQL WHENEVER SQLERROR CONTINUE;
EXEC SQL EXECUTE IMMEDIATE :sqlcommand;
return( SQLCODE );
}
The SET SQLCA statement tells the SQL preprocessor to use a SQLCA other than the default global sqlca. The sqlca must be an identifier or string that is a C language reference to a SQLCA pointer.
The current SQLCA pointer is implicitly passed to the database interface library on every Embedded SQL statement. All Embedded SQL statements that follow this statement in the C source file will use the new SQLCA. This statement is only necessary when you are writing code that is reentrant. The sqlca should reference a local variable. Any global or module static variable is subject to being modified by another thread.
None.
None.
The chapter “The Embedded SQL Interface” of the Adaptive Server Anywhere Programming Interfaces Guide
