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

• ALLOCATE DESCRIPTOR statement [ESQL]
• The SQL descriptor area (SQLDA)
• SET DESCRIPTOR statement [ESQL]

Standards and compatibility

Example

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