User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To free statement resources.

Syntax

     DROP STATEMENT [ owner.]statement-name

Parameters

     statement-name:    identifier, or host-variable

Usage

Embedded SQL.

Permissions

Must have prepared the statement.

Side effects

None.

See also

• PREPARE statement

Description

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.

Example

     1. EXEC SQL DROP STATEMENT S1;

     2. EXEC SQL DROP STATEMENT :stmt;