Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Frees memory associated with a SQL descriptor area.
DEALLOCATE DESCRIPTOR descriptor-name
descriptor-name : identifier
Frees all memory associated with a descriptor area, including the data items, indicator variables, and the structure itself.
DEALLOCATE DESCRIPTOR is part of optional SQL/2008 language feature B031, "Basic dynamic SQL".
For an example, see ALLOCATE DESCRIPTOR statement [ESQL].