SQLSTATE Variable

This variable is char[]-type and contains error and warning codes.
It is retained only for compatibility with SQL-89.
If you want to use it, write a code as follows.

char SQLSTATE[6];

SQLState can be used for checking connection-state.

char SQLSTATE[6];

...
if (memcmp (SQLSTATE, "08S01", 5) == 0 ||
    memcmp (SQLSTATE, "08001", 5) == 0 ||
    memcmp (SQLSTATE, "08003", 5) == 0 )
{
   // Handling Connection-Errors.
   ...
}

SQLCODE

This variable contains detailed error-code. user uses SQLCODE without declaring it.

EXEC SQL INSERT INTO employee VALUES (...);
if (sqlca.sqlcode != 0)
  printf("ErrCode = %d\n", SQLCODE);

SQLCA

This is variable containing error and warning-code. user uses it without declaring it.
This is structure variable as follows.

1. sqlca.sqlcode

   Status codes	Description
   0	Means that ALTIBASE HDB executed a statement without errors.
   > 0	Means that ALTIBASE HDB executed a statement with some errors. This occurs when SELECT statement without indicator-variable returned a result with NULL.
   < 0	Means that ALTIBASE HDB didn't execute a statement with some errors.

2. sqlca.sqlerrm.sqlerrmc
   It contains full-text error-messages. Its length is in sqlca.sqlerrm.sqlerrml

WJ

1. sqlca.sqlerrd
   It contains number of record processed. (ALTIBASE uses only sqlca.sqlerrd[2])

Pre-Defined Error-Code

You can refer to this document

WHENEVER

EXEC SQL WHENEVER <condition> <action>;

1. Condition
   The condition has two states. ALTIBASE HDB doesn't support "SQLWARNING".
   1. SQLERROR
   2. NOTFOUND
2. Action
   1. CONTINUE
   2. DO BREAK
   3. DO CONTINUE
   4. DO function_name
   5. GOTO label
   6. STOP
      The connection is to be closed.

Some Notices

1. APRE marks "EXEC SQL INCLUDE SQLCA" statement to a comment when precompiling it.
2. APRE marks "#include <sqlca.h>" statement to a comment when precompiling it.