Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


DEALLOCATE PREPARE


Deallocates a prepared SQL statement.

Usage

Embedded.

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.

Restrictions

None.

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, chapter 11, Dynamic SQL.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX