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
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 modules returns, you can use SQLCODE in pure C modules (modules with the .c extension) that you link to the program. To use SQLCODE in a pure C module, declare SQLCODE as an external variable, as follows:

extern int4 SQLCODE;