GET DIAGNOSTICS statement

Use the GET DIAGNOSTICS statement to return diagnostic information about the most recently executed SQL statement.

Syntax

Read syntax diagramSkip visual syntax diagram
                                           (1)     
>>-GET DIAGNOSTICS--+-| Statement Clause |-----+---------------><
                    |                      (2) |   
                    '-| EXCEPTION Clause |-----'   

Notes:
  1. See Statement Clause
  2. See EXCEPTION Clause

Usage

Use this statement with Informix® ESQL/C.

The GET DIAGNOSTICS statement retrieves specified status information that the database server records in a structure called the diagnostics area. Using GET DIAGNOSTICS does not change the contents of the diagnostics area.

The GET DIAGNOSTICS statement uses one of the following two clauses:
  • The Statement clause returns count and overflow information about errors and warnings that the most recent SQL statement generates.
  • The EXCEPTION clause provides specific information about errors and warnings that the most recent SQL statement generates.

Copyright© 2019 HCL Technologies Limited