Home | Previous Page | Next Page   Error Messages >

Diagnostic SQLSTATE Values

Each IBM Informix ODBC Driver function can return an SQLSTATE value that corresponds to an Informix error code. A function can return additional SQLSTATE values that arise from implementation-specific situations. SQLError returns SQLSTATE values as defined by the X/Open and SQL Access Group SQL CAE specification (1992).

SQLSTATE values are character strings that consist of a two-character class value followed by a three-character subclass value. A class value of 01 indicates a warning and is accompanied by a return code of SQL_SUCCESS_WITH_INFO. Class values other than 01, except for the class IM, indicate an error and are accompanied by a return code of SQL_ERROR. The class IM signifies warnings and errors that derive from the implementation of IBM Informix ODBC Driver. The subclass value 000 in any class is for implementation-defined conditions within the given class. ANSI SQL-92 defines the assignment of class and subclass values.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]