DROP STATEMENT Statement [ESQL]

Frees statement resources.

Syntax

DROP STATEMENT [ owner.]statement-name

Parameters

statement-name: – identifier or host-variable

Examples

Example 1 –

EXEC SQL DROP STATEMENT S1;
EXEC SQL DROP STATEMENT :stmt;

Usage

DROP STATEMENT frees resources used by the named prepared statement. These resources are allocated by a successful PREPARE statement, and are normally not freed until the database connection is released.

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported in Open Client/Open Server

Permissions

Must have prepared the statement.