DEALLOCATE DESCRIPTOR statement [ESQL]

Use this statement to free 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.

Permissions

None.

Side effects

None.

See also
Standards and compatibility
  • SQL/2003   Core feature.

Example

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