In the simplest case, an SQL statement is dynamically executed which returns no results except for setting the SQLCODE in the SQLCA; i.e.: this statement has no host variables. For such a case, there is the dynamic SQL statement EXECUTE IMMEDIATE.
The SQL statement which is to be executed dynamically can either be specified in a host variable or as a character string (literal).
Example:
