DECLARE CURSOR statement [T-SQL]

Description

Declares a cursor in a manner compatible with Adaptive Server Enterprise.

Syntax

DECLARE cursor-nameCURSOR FOR select-statement
…[ FORREAD ONLY | UPDATE } ]

Usage

Sybase IQ supports a DECLARE CURSOR syntax that is not supported in Adaptive Server Enterprise. For information on the full DECLARE CURSOR syntax, see DECLARE CURSOR statement [ESQL] [SP].

This section describes the overlap between the Sybase IQ and Adaptive Server Enterprise versions of DECLARE CURSOR.


Side effects

None.

Standards

Permissions

None.

See also

DECLARE CURSOR statement [ESQL] [SP]

sp_iqcursorinfo procedure in Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures