User's Guide

Part V. The SQL Anywhere Programming Interfaces

Chapter 38. The WSQL HLI Interface

Syntax

     DROP statement-name

     statement-name:    identifier, or host variable

Purpose

To free resources used by a statement.

See also

PREPARE, DECLARE.

Description

The DROP command frees resources used by a prepared statement, and unreserves the statement name (and any associated cursors). If there is a cursor associated with this statement, then it will be CLOSEd and unreserved.

This command is functionally similar to the Embedded SQL command DROP STATEMENT.