DEALLOCATE DESCRIPTOR Statement [ESQL]

Frees memory associated with a SQL descriptor area.

Syntax

DEALLOCATE DESCRIPTOR descriptor-name:
string

Examples

Usage

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

Standards

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Supported by Open Client/Open Server.

Permissions

None

Parent topic: SQL Statements
Related reference
ALLOCATE DESCRIPTOR Statement [ESQL]
SET DESCRIPTOR Statement [ESQL]