1.7.1 Diagnostics

SQL-92 defines a diagnostics area as a DBMS-managed data structure that captures specific information about the execution of a SQL statement, with the exception of the GET DIAGNOSTICS statement. A diagnostics area consists of two sections, a header and a collection of diagnostic details.

The header contains information about the last SQL statement executed, while the diagnostic details contain information about each error or warning that resulted from the execution of the SQL statement.

The size of the diagnostic details section is the default value for the DBMS implementation. This size is always greater than one, since the first diagnostic detail corresponds to sqlstate. A DBMS may only fill in one diagnostic detail regardless of the number of errors or warnings that occur. If multiple diagnostic details are filled in, there is no presumption of precedence or importance.

The SQL-ODBC library provides wrapper classes for these constructs and accessors for the information they represent.

---

OLE, COM, ActiveX and DBMS Reference - 31 MAR 2000