EXECUTE IMMEDIATE | Teradata Vantage - EXECUTE IMMEDIATE - Advanced SQL Engine - Teradata Database

SQL Stored Procedures and Embedded SQL

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
xqq1557098602407.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1148
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Prepares and executes a statement in a stored procedure.

Invocation

Executable.

Stored procedures only.

Syntax

EXECUTE IMMEDIATE statement_name
statement_name
One of the following:
  • a literal
  • a reference to an SQL string variable
  • a parameter

ANSI Compliance

ANSI/ISO SQL:2011-compliant.

Authorization

None.

Example: Using EXECUTE IMMEDIATE

CREATE PROCEDURE sales_update(store_table VARCHAR(10),
							     item INTEGER,
							     price DECIMAL(8,2) )
		BEGIN
			DECLARE sql_stmt VARCHAR(100);
			SET
			SET sql_stmt = 'UPDATE ' || store_table ||  ' SET store_price=' || price ||
					' WHERE store_item =' || item;
			EXECUTE IMMEDIATE sql_stmt;
    END;