Programming Guide



@dmengsqlstate

Contains an engine-specific status code for error conditions

Description

Some database engines support a SQLSTATE status code which is updated after each SQL statement.

SQLSTATE is a five-character string which can be set for warning or error conditions. In Panther, warning conditions from SQLSTATE are written to @dmwarnsqlstate; error conditions are written to @dmengsqlstate.

If the database engine does not support SQLSTATE, the value of @dmengsqlstate will be "00000", the value which represents success.

A "00000" (five zeros) value in this variable does not guarantee that the last statement executed without error. Some errors are detected by Panther's database driver before a request is made to the engine. For example, if an application attempts a SELECT before declaring a connection, Panther detects the error. Use the global variable @dmretcode to check for errors in Panther's database drivers.

Because the value of @dmengsqlstate is engine-specific, it is strongly recommended that you install an error handler to test for these errors.

If the application accesses multiple database engines, the database driver for each engine must support SQLSTATE in order to use its values for application processing. @dmengsqlstate is set to "00000" before each DBMS statement. If you need its value for further processing, it should be copied to another variable.