ASA SQL Reference

SQL Statements

DEALLOCATE statement

Description 

Use this statement to free resources associated with a cursor.

Syntax 

DEALLOCATE [ CURSOR ] cursor-name

cursor-name : identifier

Usage 

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

This option has no effect in Adaptive Server Anywhere. It is provided for compatibility with Adaptive Server Enterprise and Microsoft SQL Server. In Adaptive Server Enterprise, the CURSOR keyword is required. In Microsoft SQL Server, the keyword is not permitted. Adaptive Server Anywhere recognizes both forms.

Permissions 

None.

Side effects 

None.

See also 

• DECLARE CURSOR statement [ESQL] [SP]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Supported by Adaptive Server Enterprise.

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