Progress
Embedded SQL-92
Guide and Reference
EXECUTE IMMEDIATE Statement
The EXECUTE IMMEDIATE statement is similar to using PREPARE and then EXECUTE. The EXECUTE IMMEDIATE statement accepts as input a character string or a host variable of character array type. A dynamic statement that will be executed with EXECUTE IMMEDIATE cannot contain any dynamic parameters.
EXAMPLESThe following examples show how to use the EXECUTE IMMEDIATE statement:
A character string can be used in place of a host variable reference, as follows:
The SQL string given to an EXECUTE IMMEDIATE statement should not have host variable references.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |