Use this statement to free statement resources.
DROP STATEMENT [ owner.]statement-name
statement-name : identifier | hostvar
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.
Must have prepared the statement.
None.
SQL/2003 Vendor extension.
The following are examples of DROP STATEMENT use:
EXEC SQL DROP STATEMENT S1; EXEC SQL DROP STATEMENT :stmt; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |