EXECUTE ------+-> statement-name -+--------------+
               +-> parameter ------+              |
 +-----------------------<------------------------+
 +---+----------------------->--------------------+-> ;
     +-> USING -+-+-> parameter -+--------------+-+
                | +------ , <----+              |
                +-> DESCRIPTOR 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.