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 SQLSTATE
Check for exceptions with SQLSTATE
Determining the cause of an exception in SQLSTATETo determine the cause of an exception in SQLSTATE, use the GET DIAGNOSTICS statement.

Determining the cause of an exception in SQLSTATE

To determine the cause of an exception in SQLSTATE, use the GET DIAGNOSTICS statement.

About this task

To determine the cause of an exception in SQLSTATE:

Use GET DIAGNOSTICS to obtain the statement information such as the number of exceptions that the database server has generated.
For each exception, use the EXCEPTION clause of GET DIAGNOSTICS to obtain detailed information about the exception.