SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-54
GET DIAGNOSTICS Statement
GET DIAGNOSTICS Statement
Considerations for GET DIAGNOSTICS
C Examples of GET DIAGNOSTICS
COBOL Examples of GET DIAGNOSTICS
The GET DIAGNOSTICS statement returns information from the diagnostics area
about the most recently executed statement and its exception status and assigns the
specified statement and condition information to host variables.
Use GET DIAGNOSTICS only in embedded SQL programs in C or COBOL.
GET DIAGNOSTICS {statement-info | condition-info}
statement-info is:
statement-item [,statement-item]...
statement-item is:
variable-name = statement-item-name
statement-item-name is:
NUMBER
| MORE
| COMMAND_FUNCTION
| DYNAMIC_FUNCTION
| ROW_COUNT
condition-info is:
EXCEPTION condition-nbr
condition-item [,condition-item]...
condition-item is:
variable-name = condition-item-name
C/COBOL