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:
