DEALLOCATE DESCRIPTOR

Deallocates an SQL descriptor area.

deallocate_descriptor.png

 

Usage

Embedded/Module.

Description

This statement deallocates an SQL descriptor area that was previously allocated with the specified descriptor-name.

Notes

An SQL descriptor area with the specified name must have been previously allocated.

Example

EXEC SQL DEALLOCATE DESCRIPTOR 'SDA';

Standard Compliance

Standard

Compliance

Comments

SQL-2016

Features outside core

Feature B031, “Basic dynamic SQL”.

Feature B032, “Extended dynamic SQL” support for dynamic descriptor names.