Reference Manual
   CHAPTER 9. SQL Statements     

DEALLOCATE DESCRIPTOR statement [ESQL]

Function 

Frees memory associated with a SQL descriptor area.

Syntax 

DEALLOCATE DESCRIPTOR descriptor-name

Permissions 

None.

Side effects 

None.

See also 

ALLOCATE DESCRIPTOR statement

The SQL descriptor area (SQLDA)

SET DESCRIPTOR statement

Description 

Frees all memory associated with a descriptor area, including the data items, indicator variables, and the structure itself.

Standards and compatibility 

• SQL/92     Entry-level feature.

• Sybase     Supported by Open Client/Open Server.

Example 

• For an example, see ALLOCATE DESCRIPTOR statement.