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 topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, 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
Exception handling with the sqlca structureAn alternative way to obtain diagnostic information is through the SQL Communications Area. When an SQL statement executes, the database server automatically returns information about the success or failure of the statement in a C structure that is called sqlca.
The SQLCODE variableThe SQLCODE variable is an int4 that indicates whether the SQL statement succeeded or failed.
SQLCODE in pure C modules

SQLCODE in pure C modules

To return the same values that the SQLCODE status variable in HCL OneDB™ ESQL/C modules returns, you can use SQLCODE in pure C modules (modules with the .c extension) that you link to the HCL OneDB ESQL/C program. To use SQLCODE in a pure C module, declare SQLCODE as an external variable, as follows:

extern int4 SQLCODE;