SQL Statements › SQL Statements › CREATE PROCEDURE Statement › GET DIAGNOSTICS Syntax

GET DIAGNOSTICS Syntax

►►─ GET ─┬───────────┬─ DIAGNOSTICS ──────────────────────────────────────────►
         ├─ CURRENT ─┤
         └─ STACKED ─┘

 ►─┬──────────────────────────────────┬─┤diagnostic-info-items├───────────────►◄
   └─ CONDITION ─ integer-expression ─┘

Expansion of diagnostic-info-items

   ┌─ , ───────────────────────┐
├──▼─┬─┤statement-info-item├─┬─┴───────────────────────────────────────────────┤
     └─┤condition-info-item├─┘

Expansion of statement-info-item

   ┌─ , ────────────────────────────────────────────────┐
├──▼─┬─ SQL-variable-name ──┬─statement-info-item-name ─┴──────────────────────┤
     └─ SQL-parameter-name ─┘

Expansion of statement-info-item-name

├──┬─ NUMBER ─┬────────────────────────────────────────────────────────────────┤
   └─ MORE ───┘

Expansion of condition-info-item

   ┌─ , ────────────────────────────────────────────┐
├──▼─┬─ SQL-variable-name ──┬─┤cond-info-item-name├─┴──────────────────────────┤
     └─ SQL-parameter-name ─┘

Expansion of cond-info-item-name

├──┬─ CONDITION_NUMBER ─────┬──────────────────────────────────────────────────┤
   ├─ MESSAGE_LENGTH ───────┤
   ├─ MESSAGE_TEXT ─────────┤
   ├─ RETURNED_SQLSTATE ────┤
   └─ CONDITION_IDENTIFIER ─┘

CURRENT and STACKED are optional choices for specifying which diagnostics area to use.

CONDITION followed by an integer is an optional specification for which condition area to use. If you do not specify CONDITION, a default of CONDITION 1 is used.

A specific data type appears in parentheses as shown following each information item name.