Declares a cursor that is compatible with Adaptive Server Enterprise.
DECLARE cursor-name … CURSOR FOR select-statement …[ FOR { READ ONLY | UPDATE } ]
SAP 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].
SQL—The FOR UPDATE and FOR READ ONLY options are Transact-SQL extensions to ISO/ANSI SQL grammar.
Sybase—There are some features of the Adaptive Server Enterprise 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 Enterprise, 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).
None