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.

Parent topic: Using the SQLSTATE Error Status Code
Copyright© 2021 HCL Technologies Limited