Home
SQL programmingYou can use the HCL Informix® implementation of the SQL language to develop applications for Informix® database servers.
Guide to SQL: Syntax
SQL Statements
GET DIAGNOSTICS statementUse the GET DIAGNOSTICS statement to return diagnostic information about the most recently executed SQL statement.
Using the SQLSTATE Error Status Code
SQLSTATE Support for the ANSI/ISO Standard for SQL

SQLSTATE Support for the ANSI/ISO Standard for SQL

All status codes returned to the SQLSTATE variable are ANSI-compliant except in the following cases:

SQLSTATE codes with a class code of 01 and a subclass code that begins with an I are Informix®-specific warning messages.
SQLSTATE codes with a class code of IX and any subclass code are Informix-specific error messages.
SQLSTATE codes whose class code begins with a digit in the range 5 to 9 or with an uppercase letter in the range I to Z indicate conditions that are currently undefined by the ANSI/ISO standard for SQL. The only exception is that SQLSTATE codes whose class code is IX are Informix-specific error messages.

Client-server communication protocols of Informix, such as SQLI and DRDA®, support these SQLSTATE code values.