Progress
SQL-92
Guide and Reference
EXECUTE IMMEDIATE Statement
Executes the statement specified in a statement_string or host_variable.
SYNTAX
statement_name
Name of the prepared SQL-92 statement.
structure_name
Name of an SQL-92 descriptor area (SQLDA).
NOTES
- The character string form of the statement is referred to as a statement string. An EXECUTE IMMEDIATE statement accepts either a statement string or a host variable as input.
- A statement string must not contain host variable references or parameter markers.
- A statement string must not begin with EXEC SQL Delimiter and must not end with a semicolon.
- When an EXECUTE IMMEDIATE statement is executed, the SQL engine parses the statement and checks it for errors. Any error in the execution of the statement is reported in the SQLCA.
- If the same SQL-92 statement is to be executed multiple times, it is more efficient to use PREPARE and EXECUTE statements, rather than an EXECUTE IMMEDIATE statement.
AUTHORIZATION
(See AUTHORIZATION for the relevant statement)
SQL COMPLIANCE
SQL-92
ENVIRONMENT
Embedded SQL-92 only
RELATED STATEMENTS
EXECUTE Statement, SQLCA structure
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |