SQL Statements › SQL Statements › CREATE PROCEDURE Statement › RESIGNAL Syntax

RESIGNAL Syntax

►►─ RESIGNAL ─┬───────────────┬─┬─────────────────────┬───────────────────────►◄
              └─┤signal-value├┘ └─┤signal-information├┘

Expansion of signal-value

├──┬─ condition-name ─┬────────────────────────────────────────────────────────┤
   └─ sqlstate-value ─┘

Expansion of signal-information

├── SET ─┤signal-info-item-list├───────────────────────────────────────────────┤

Expansion of signal-info-item-list

   ┌─ , ────────────────┐
├──▼─ signal-info-item ─┴──────────────────────────────────────────────────────┤

Expansion of signal-info-item

├── condition-info-item-name = proc-value-expression ──────────────────────────┤

A proc-value-expression is a variant form of the expressions used to specify values (see the information about expressions in the CA Datacom/DB SQL User Guide)