Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
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 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.