Show TOC

SET SQLCA Statement [ESQL]Locate this document in the navigation structure

Tells the SQL preprocessor to use a SQLCA other than the default global <sqlca>.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Standards

Go to Permissions

Syntax
SET SQLCA <sqlca>
Parameters

(back to top)

  • sqlca

    identifier or string
Examples

(back to top)

  • Example 1 this function can 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 );
}
Usage

(back to top)

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 use the new SQLCA. This statement is necessary only 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.

Standards

(back to top)

  • SQL—Vendor extension to ISO/ANSI SQL grammar.
  • SAP Database products—Not supported by Open Client/Open Server.
Permissions