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 

• SQL/92    Entry-level feature.

• SQL/99    Core feature.

• Sybase    Supported by Open Client/Open Server.

Example 

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

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.