DROP STATEMENT statement [ESQL]

Description

Frees statement resources.

Syntax

DROP STATEMENT [ owner.]statement-name

Parameters

Examples

Example 1

• The following are examples of DROP STATEMENT use:

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

Usage

The DROP STATEMENT 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.

None.

Standards

Permissions

Must have prepared the statement.

See also