DECLARE CURSOR Statement [T-SQL]

Declares a cursor that is compatible with Adaptive Server.

Quick Links:

Go to Usage

Go to Standards

Go to Permissions

Syntax

DECLARE cursor-name
   … CURSOR FOR select-statement
   …[ FOR { READ ONLY | UPDATE } ]

Usage

(back to top)

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

Note: Use the sp_iqcursorinfo system procedure to display detailed information about cursors currently open on the server.

Standards

(back to top)

  • SQL—The FOR UPDATE and FOR READ ONLY options are Transact-SQL extensions to ISO/ANSI SQL grammar.
  • SAP Sybase Database product—There are some features of the Adaptive Server DECLARE CURSOR statement that are not supported in SAP Sybase IQ.
    • In the SAP Sybase IQ dialect, DECLARE CURSOR in a procedure or batch must immediately follow the BEGIN keyword. In the Transact-SQL dialect, there is no such restriction.
    • In Adaptive Server, when a cursor is declared in a procedure or batch, it exists for the duration of the procedure or batch. In SAP Sybase IQ, if a cursor is declared inside a compound statement, it exists only for the duration of that compound statement (whether it is declared in an SAP Sybase IQ or Transact-SQL compound statement).

Permissions

(back to top)

None

Parent topic: SQL Statements
Related reference
DECLARE CURSOR Statement [ESQL] [SP]