ASA SQL Reference
  SQL Statements

DROP STATEMENT statement [ESQL]

Description 

Use this statement to free statement resources.

Syntax 

DROP STATEMENT [ owner.]statement-name

statement-name : identifier | hostvar

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.

Permissions 

Must have prepared the statement.

Side effects 

None.

See also 

PREPARE statement [ESQL]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported in Open Client/Open Server

Example 

The following are examples of DROP STATEMENT use:

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