DEALLOCATE DESCRIPTOR statement [ESQL]

Frees memory associated with a SQL descriptor area.

Syntax

DEALLOCATE DESCRIPTOR descriptor-name

descriptor-name : identifier

Remarks

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

Privileges

None.

Side effects

None.

Standards

ANSI/ISO SQL Standard
DEALLOCATE DESCRIPTOR is part of optional ANSI/ISO SQL Language Feature B031, "Basic dynamic SQL".