Contents Index DEALLOCATE statement Declaration section [ESQL]

ASA SQL Reference
  SQL Statements

DEALLOCATE DESCRIPTOR statement [ESQL]


Description 

Use this statement to free memory associated with a SQL descriptor area.

Syntax 

DEALLOCATE DESCRIPTOR descriptor-name

descriptor-name : string

Usage 

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].


Contents Index DEALLOCATE statement Declaration section [ESQL]