EXECUTE statement-name ─┬─────────────────────────────────────────────┬─> typebox (;)
                         └─> 
U
S
I
N
G ──┬─┬─> parameter ─┬──────────────┬─┘
                                     │ └────── , <────┘              │
                                     └─> 
D
E
S
C
R
I
P
T
O
R descriptor-name ─┘

Additional information available:

USING

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.

 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.