Alphabetical list of options
206
This option controls whether rows are fetched to the client side in advance of
being made available to the client application. Fetching a number of rows at
a time, even when the client application requests rows one at a time (for
example, when looping over the rows of a cursor) cuts down on response
time and improves overall throughput by cutting down the number of
requests to the database.
The setting of PREFETCH is ignored by Open Client and JDBC
connections.
$ For more information, see
♦ "Prefetching rows" on page 278 of the book ASA User’s Guide
♦ "DisableMultiRowFetch connection parameter" on page 57
QUALIFY_OWNERS option
Controls whether SQL statements being replicated by SQL Remote should
use qualified object names.
ON, OFF
The default in Adaptive Server Anywhere is ON. The default in Adaptive
Server Enterprise is OFF.
Qualifying owners in Adaptive Server Enterprise setups is rarely needed
because it is common for objects to be owned by dbo. When qualification is
not needed in Adaptive Server Anywhere setups, messages will be slightly
smaller with the option OFF.
QUERY_PLAN_ON_OPEN option
Controls whether a plan is returned when a cursor is opened.
ON, OFF
OFF
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
To Next Page
Loading...