DROP STATEMENT statement [ESQL]

Use this statement to free statement resources.

Syntax
DROP STATEMENT [ owner.]statement-name
statement-name : 
identifier 
| hostvar
Remarks

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
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following are examples of DROP STATEMENT use:

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