Progress
Embedded SQL-92
Guide and Reference
EXECUTE Statement
Executes the statement specified in statement_name.
SYNTAX
statement_name
The name of the prepared SQL-92 statement.
structure_name
The name of an SQL-92 descriptor area (SQLDA).
EXAMPLEThis example is a code fragment from the
DynUpd
function in sample program 3DynUpd.pc. This example illustrates the dynamic processing of an UPDATE statement The complete source for the sample program is listed in "ESQL-92 Sample Programs."
NOTES
- A statement must be processed with a PREPARE Statement before it can be processed with an EXECUTE Statement.
- A prepared statement can be executed multiple times in the same transaction. Typically each call to the EXECUTE Statement supplies a different set of host variables.
- If there is no DESCRIPTOR in the USING clause, the EXECUTE Statement is restricted to the number of variables specified in the host variable list. The number and type of the variables must be known at compile time. The host variables must be declared in the DECLARE SECTION before they can be used in the USING clause of the EXECUTE Statement.
- If there is a DESCRIPTOR in the USING clause, the program can allocate space for the input host variables at run-time.
AUTHORIZATION
The user executing this statement must have authorization for the SQL statement being executed. See AUTHORIZATION for the relevant statement.
SQL COMPLIANCE
SQL-92
ENVIRONMENT
Embedded SQL-92 only
RELATED STATEMENTS
EXECUTE Statement, PREPARE Statement, SQLCA structure
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |