RDB/VMS SQL WHENEVER — VMS SQLdev_2.0
WHENEVER ──┬─>
N
O
T
F
O
U
N
D ──┬─┬─>
C
O
N
T
I
N
U
E ──────────────┬─> typebox (;) ├─>
S
Q
L
E
R
R
O
R ───┤ ├─>
G
O
T
O ──┬─> host-label ─┘ └─>
S
Q
L
W
A
R
N
I
N
G ─┘ └─>
G
O
T
O ─┘
Additional information available:
More Information
You can issue the WHENEVER statement only in precompiled programs. The WHENEVER statement specifies the execution path a host program will take when any embedded SQL statement results in one of these following exception conditions: o Row not found o An error condition o A warning condition For the condition, WHENEVER either specifies that the program continue execution or branch to another part of the program.