SQL support / Dynamic SQL management |
Performs a simple SQL execution without SQL parameters or result set.
EXECUTE IMMEDIATE sqltext
The EXECUTE IMMEDIATE instruction passes an SQL statement to the database server for execution in the current database connection.
The SQL statement used by EXECUTE IMMEDIATE must be a single statement without SQL parameters and must not produce a result set.
This instruction is equivalent to PREPARE, EXECUTE and FREE in one step.
MAIN DATABASE stores EXECUTE IMMEDIATE "UPDATE tab SET col='aaa' WHERE key=345" END MAIN