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 HCL OneDB™-specific warning messages.
  • SQLSTATE codes with a class code of IX and any subclass code are HCL OneDB-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 HCL OneDB-specific error messages.

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