Sybase Adaptive Server Anywhere - Page 627

Chapter 9 SQL Statements
609
In Adaptive Server Anywhere, if the ROWCOUNT setting is greater
than the number of rows that Interactive SQL can display, Interactive
SQL may do some extra fetches to reposition the cursor. Thus, the
number of rows actually displayed may be less than the number
requested. Also, if any rows are re-fetched due to truncation warnings,
the count may be inaccurate.
A value of zero resets the option to get all rows.
♦
SET SELF_RECURSION { ON | OFF } The self_recursion option is
used within triggers to enable (ON) or prevent (OFF) operations on the
table associated with the trigger from firing other triggers.
♦
SET STRING_RTRUNCATION { ON | OFF } The default behavior in
Adaptive Server Anywhere and Adaptive Server Enterprise when non-
space characters are truncated on assigning SQL string data is different.
Setting STRING_RTRUNCATION to ON provides Transact-SQL-
compatible string comparisons.
♦
SET TEXTSIZE Specifies the maximum size (in bytes) of text or image
type data to be returned with a select statement. The @@textsize global
variable stores the current setting. To reset to the default size (32K),
which is also the maximum setting, use the command:
set textsize 0
♦ SET TRANSACTION-ISOLATION-LEVEL { 0 | 1 | 2 | 3 } Sets the
locking isolation level for the current connection, as described in
"Isolation levels and consistency" on page 386 of the book ASA User’s
Guide. For Adaptive Server Enterprise, only 1 and 3 are valid options.
For Adaptive Server Anywhere, any of 0, 1, 2, or 3 is a valid option.
In addition, the SET statement is allowed by Adaptive Server Anywhere for
the PREFETCH option, for compatibility, but has no effect:
♦
SQL/92 Transact-SQL extension
♦
Sybase Adaptive Server Anywhere supports a subset of the Adaptive
Server Enterprise database options.
Standards and
compatibility