@dmwarnsqlstate

Contains an engine-specific status code indicating a warning

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 Prolifics, warning conditions from SQLSTATE are written to @dmwarnsqlstate; error conditions are written to @dmengsqlstate.

By default, Prolifics ignores warnings. If an application needs to alert users to warning codes, it must use a JPL or C function to check for them. There is no default warning handler. The most efficient way to process warning codes is with an installed exit handler using DBMS ONEXIT.

If the database engine does not support SQLSTATE, the value of @dmwarnsql state will be 0, the value which represents success.

If the application accesses multiple database engines, the database driver for each engine must support SQLSTATE in order to use its values for application process ing.@dmwarnsqlstate, like all @dm variables, is set to 0 before each DBMS statement. If you need its value for further processing, it should be copied to another variable.