Chapter 5 Database Options
207
In early versions of the software, each time an OPEN was done on a cursor,
the server would return in the SQLCA sqlerrmc field a string representing
the query plan (limited to 70 bytes). A more complete description can be
obtained using the EXPLAIN statement or the PLAN function. For this
reason, computing and returning the query plan on an OPEN is needed only
for compatibility with old applications. The QUERY_PLAN_ON_OPEN
option controls whether the plan is returned on an OPEN. By default, the
setting is OFF.
QUOTE_ALL_IDENTIFIERS option
Controls whether SQL statements being replicated by SQL Remote should
use quoted identifiers
ON, OFF
OFF
When this option is off,
dbremote
quotes identifiers that require quotes by
Adaptive Server Anywhere (as it has always done) and
ssremote
does not
quote any identifiers.
When the option is on, all identifiers are quoted.
QUOTED_IDENTIFIER option
Controls the interpretation of strings that are enclosed in double quotes.
ON, OFF
ON
OFF for Open Client and JDBC connections
This option controls whether strings that are enclosed in double quotes are
interpreted as identifiers (ON) or as literal strings (OFF). The
QUOTED_IDENTIFIER option is included for Transact-SQL compatibility.
Sybase Central sets QUOTED_IDENTIFER temporarily to ON if it is set to
OFF. A message is displayed informing you of this change. The change is in
effect only for the Sybase Central connection.
$ For more information, see "Setting options for Transact-SQL
compatibility" on page 969 of the book ASA User’s Guide.
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...