EXECUTE IMMEDIATE
EXECUTE IMMEDIATE — dynamically prepare and execute a statement
Synopsis
EXECUTE IMMEDIATEstringDescription
EXECUTE IMMEDIATE immediately prepares and executes a dynamically specified SQL statement, without retrieving result rows.
Parameters
string#A literal string or a host variable containing the SQL statement to be executed.
Notes
In typical usage, thestring is a host variable reference to a string containing a dynamically-constructed SQL statement. The case of a literal string is not very useful; you might as well just write the SQL statement directly, without the extra typing ofEXECUTE IMMEDIATE.
If you do use a literal string, keep in mind that any double quotes you might wish to include in the SQL statement must be written as octal escapes (\042) not the usual C idiom\". This is because the string is inside anEXEC SQL section, so the ECPG lexer parses it according to SQL rules not C rules. Any embedded backslashes will later be handled according to C rules; but\" causes an immediate syntax error because it is seen as ending the literal.
Examples
Here is an example that executes anINSERT statement usingEXECUTE IMMEDIATE and a host variable namedcommand:
sprintf(command, "INSERT INTO test (name, amount, letter) VALUES ('db: ''r1''', 1, 'f')");EXEC SQL EXECUTE IMMEDIATE :command;Compatibility
EXECUTE IMMEDIATE is specified in the SQL standard.