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 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