RDB/VMS SQL EXECUTE — VMS RDB_4.0
EXECUTE ──────┬─> statement-name ─┬──────────────┐ └─> parameter ──────┘ │ ┌───────────────────────<────────────────────────┘ └───┬───────────────────────>────────────────────┬─> typebox (;) └─>
U
S
I
N
G ─┬─┬─> parameter ─┬──────────────┬─┘ │ └────── , <────┘ │ └─>
D
E
S
C
R
I
P
T
O
R descriptor-name ─┘
Additional information available:
More Information
The EXECUTE statement dynamically executes a previously prepared statement. EXECUTE is a dynamic SQL statement and can be used only in precompiled programs or as part of an SQL module language procedure. It cannot be used in interactive SQL.
USING
Specifies parameters (parameters in a prepared statement in a precompiled program or formal parameters in a prepared statement that is part of an SQL module language procedure) whose values SQL uses to replace parameter markers in the prepared statement string. If the program determines that a statement string had no parameter markers, the USING clause is optional. To specify the parameters, either list them or name a descriptor that contains their addresses and data types. The number of parameters in the list or the number of elements in the descriptor must be the same as the number of parameter markers in the statement string of the prepared statement. If you name a descriptor, it must be a structure declared in the host program as an SQLDA. If the program is precompiled and uses the embedded SQL statement INCLUDE SQLDA, the name of the structure is simply SQLDA. Programs can use multiple SQLDAs but must explicitly declare them with names other than SQLDA.