DEALLOCATE DESCRIPTOR - Release SQL descriptor area

You use DEALLOCATE DESCRIPTOR to release an SQL descriptor area.

You must have previously created the descriptor area with ALLOCATE DESCRIPTOR.

---

DEALLOCATE DESCRIPTOR GLOBAL descriptor

---

descriptor

Name of the SQL descriptor area to be released.
You cannot release the descriptor area if there is an open cursor with block mode activated in the same compilation unit (see section "PREFETCH pragma") and a FETCH NEXT... statement has been executed for this cursor whose INTO clause contains the name of the same SQL descriptor area.

Example

Release SQL descriptor area The descriptor area name is contained in the host variable DEMO_DESC.

DEALLOCATE DESCRIPTOR GLOBAL descriptor :demo_desc

See also

ALLOCATE DESCRIPTOR, DESCRIBE, GET DESCRIPTOR, SET DESCRIPTOR