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.
Check for exceptions with sqlca
Runtime errors in SQLCODEWhen an SQL statement results in a runtime error, the database server sets SQLCODE (and sqlca.sqlcode) to a negative value. The actual number identifies the particular error. The error message documentation lists the error codes specific to HCL OneDB™ and their corrective actions.
SQLCODE after an EXECUTE statement

SQLCODE after an EXECUTE statement

After an EXECUTE statement, the database server sets SQLCODE to indicate the success of the prepared statement as follows:

If the database server cannot execute a prepared statement successfully, it sets SQLCODE to a value less than 0. The SQLCODE variable holds the error that the database server returns from the statement that failed.
If the database server can successfully execute the prepared statement in the block, it sets SQLCODE to 0; if the prepared block includes multiple statements, all of the statements succeeded.