![SUBQUERY_FLATTENING_PREFERENCE allowed values [CR 622967]](arrow-left.gif){kind=icon}
![SUBQUERY_CACHING_PREFERENCE option default [CR 622968]](arrow-right.gif){kind=icon}
The section “SQL Statements > DELETE statement” currently states: “The Transact-SQL® ROWCOUNT option has no effect on DELETE operations in Sybase IQ.” This sentence should be removed.
The section “SQL Statements > UPDATE statement” currently states: “The Transact-SQL ROWCOUNT option has no effect on UPDATE operations in Sybase IQ.” This sentence should be removed.
The section “SQL Statements > SET statement [T-SQL]” currently contains this note:
The ROWCOUNT option has no effect
on UPDATE and DELETE operations
in Sybase IQ. Also note that Sybase IQ does not support the @@rowcount global
variable.
This note should be changed to:
Sybase IQ supports the @@rowcount global
variable. The SELECT, INSERT, DELETE,
and UPDATE statements affect the ROWCOUNT option.
The ROWCOUNT option has no effect on cursor operation,
the IF statement, or creating/dropping
a table or procedure.
