Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
ESQL/C GuideThe Informix® ESQL/C Programmer's Manual explains how to use Informix® ESQL/C, the Informix® 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:

Procedure

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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.