DEALLOCATE DESCRIPTOR statement [ESQL]

Description

Frees memory associated with a SQL descriptor area.

Syntax

DEALLOCATE DESCRIPTOR descriptor-name:
string

Examples

Example 1

For an example, see ALLOCATE DESCRIPTOR statement [ESQL].

Usage

Frees all memory associated with a descriptor area, including the data items, indicator variables, and the structure itself.

Side effects

None.

Standards

SQL/92 Entry-level feature.

Sybase Supported by Open Client/Open Server.

Permissions

None.

See also

The chapter “The Embedded SQL Interface” of the Adaptive Server Anywhere Programming Interface Guide.

SET DESCRIPTOR statement [ESQL]