Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe HCL OneDB™ ESQL/C Programmer's Manual explains how to use , the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
Database server communication
Exception handling
Obtain diagnostic information after an SQL statement
Types of status variables

Types of status variables

The following methods obtain diagnostic information about the outcome of an SQL statement:

Access the SQLSTATE variable, a five-character string that contains status values that conform to the ANSI and X/Open standards
Access the SQLCODE variable, an int4 integer that contains status values that are specific to HCL OneDB™

When you create applications that must conform to either the ANSI or X/Open standard, use the SQLSTATE variable as your primary exception-handling method.