EXECUTE IMMEDIATE

The EXECUTE IMMEDIATE statement in SQL Script dynamically executes certain SQL statements.

Syntax

EXECUTE IMMEDIATE <valueExpr>

Remarks

•

The <valueExpr> must evaluate to a string type (CHAR or VARCHAR). The text in this string is executed as SQL.

•

This form of dynamic SQL is useful mainly for INSERT, UPDATE, and DELETE statements. It has no value to SELECT, because the selections cannot be assigned to anything. See the OPEN FOR statement used in OPEN for information about how to perform a dynamic SELECT.

Example

PROCEDURE drop (IN table_name VARCHAR)

BEGIN

  DECLARE sql_stmt VARCHAR;

  SET sql_stmt

  = CAST(CONCAT(‘DELETE FROM ‘, table_name) AS VARCHAR);

  EXECUTE IMMEDIATE sql_stmt;

END