|
This SQL statement can be executed in the following ways: |
Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive) |
In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded) |
By using CA Dataquery (SQL & Batch Modes) |
|---|---|---|---|
|
WHENEVER |
|
YES |
|
Note: YES indicates a valid execution method for this statement. For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.
The WHENEVER statement identifies the statement that is to be executed next if execution of the latest SQL statement produces a specified condition.
Following is the syntax diagram for the WHENEVER statement:
Note: SQLWARNING is a CA Datacom/DB extension.
►►─ WHENEVER ─┬─ NOT FOUND ──┬─┬─ CONTINUE ───────────────┬───────────────────►◄ ├─ SQLERROR ───┤ └─┬─ GOTO ──┬─ host-label ─┘ └─ SQLWARNING ─┘ └─ GO TO ─┘
|
Copyright © 2014 CA.
All rights reserved.
|
|