SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-131
EXECUTE Statement
EXECUTE Statement
Considerations for EXECUTE
MXCI Examples of EXECUTE
C Examples of EXECUTE
COBOL Examples of EXECUTE
The EXECUTE statement executes an SQL statement previously compiled by a
PREPARE statement. You can use EXECUTE in an MXCI session or in an embedded
SQL program.
Input data can be supplied either by using host variables or through an SQL descriptor
area in an embedded SQL program. Similarly, you can place output data either directly
into host variables or into an SQL descriptor area. For more information, see the
SQL/MX Programming Manual for C and COBOL.
statement-name
is the name of a prepared SQL statement—that is, the statement name used in the
PREPARE statement. statement-name is an SQL identifier. See Identifiers on
page 6-52.
The statement name is not case-sensitive in MXCI.
The statement name is case-sensitive in embedded SQL—for example, the
statement named findemp is not equivalent to the statement named FINDEMP.
EXECUTE statement-name
[USING param-value [,param-value]...]
EXECUTE statement-name
[USING {argument-list | descriptor-spec}]
[INTO {argument-list | descriptor-spec}]
statement-name is:
statement-name | ext-statement-name
argument-list is:
variable-spec [,variable-spec]...
descriptor-spec is:
SQL DESCRIPTOR descriptor-name
ext-statement-name is:
[GLOBAL | LOCAL] value-specification
variable-spec is:
:variable-name [[INDICATOR] :indicator-name]
descriptor-name is:
[GLOBAL | LOCAL] value-specification
C/COBOL
MXCI
C/COBOL
MXCIC/COBOL