DEALLOCATE PREPARE

Deallocates a prepared SQL statement.

deallocate_prepare.png

 

Usage

Embedded/Module.

Description

The prepared statement associated with the statement name is destroyed. Any cursor allocated with an ALLOCATE CURSOR statement that is associated with the prepared statement is also destroyed.

See ALLOCATE CURSOR for a description of extended statements.

Notes

The statement name must identify a statement prepared in the same compilation unit.

The statement must not identify an existing prepared statement that is associated with an open cursor.

Example

EXEC SQL DEALLOCATE PREPARE :stm1;

 

For more information, see the Mimer SQL Programmer's Manual, Dynamic SQL.

Standard Compliance

Standard

Compliance

Comments

SQL-2016

Features outside core

Feature B032, “Extended dynamic SQL”.