Identifier: dberr

Type

numeric

Description

The external database error status flag. When an error occurs during communication with an external database, e.g. on failure of an SQL command within a db or dbtrans command language block, dberr is set to 1.

It is reset to 0 automatically at the beginning of a db or dbtrans command. It can also be set by the user. At the end of a dbtrans command block, the value of dberr determines whether a commit or rollback is to be performed on the database transaction.

dberr is also set to 1 by the failure of a dbstructure object to communicate properly with its parent external database.

Whenever dberr gets set, the .sqlcode element of the relevant database identifier can be used to access the internal number of the error.

See Also