DEALLOCATE PREPARE | Teradata Vantage - DEALLOCATE PREPARE - Advanced SQL Engine - Teradata Database

Releases a previously prepared statement.

ANSI Compliance

ANSI/ISO SQL:2011-compliant.

Required Privileges

None.

Invocation

Executable.

Stored procedures.

Syntax

DEALLOCATE PREPARE statement_name ;

Syntax Elements

statement_name

The same identifier as statement name in a PREPARE statement.

Example: Using DEALLOCATE PREPARE

DECLARE sql_stmt1 VARCHAR(100);
DECLARE item INTEGER;
DECLARE price DECIMAL(8,2);
SET sql_stmt1 = 'INSERT INTO T1 (?,?);';
PREPARE stmt1 FROM sql_stmt1;
SET item = 1052;
SET price = 3.95;
EXECUTE stmt1 USING item, price;
SET item = 3967;
SET price = 10.85;
EXECUTE stmt1 USING item, price;
DEALLOCATE PREPARE stmt1;