Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 511 / 536

CHAPTER 14 Adaptive Server IQ as a Data Server
491
Characteristics of Open Client and jConnect
connections
When Adaptive Server IQ is serving applications over TDS, it automatically
sets relevant database options to values that are compatible with Adaptive
Server Enterprise default behavior. These options are set temporarily, for the
duration of the connection only. They can be overridden by the client
application at any time.
Default settings
The database options that are set on connection using TDS are as follows:
How the startup
options are set The default database options are set for TDS connections using a system
procedure named
sp_tsql_environment
. This procedure sets the following
options:
SET TEMPORARY OPTION TSQL_VARIABLES=’ON’;
SET TEMPORARY OPTION ANSI_BLANKS=’ON’;
SET TEMPORARY OPTION TSQL_HEX_CONSTANT=’ON’;
SET TEMPORARY OPTION CHAINED=’OFF’;
SET TEMPORARY OPTION QUOTED_IDENTIFIER=’OFF’;
SET TEMPORARY OPTION ALLOW_NULLS_BY_DEFAULT=’OFF’;
SET TEMPORARY OPTION AUTOMATIC_TIMESTAMP=’ON’;
SET TEMPORARY OPTION ANSINULL=’OFF’;
SET TEMPORARY OPTION CONTINUE_AFTER_RAISERROR=’ON’;
SET TEMPORARY OPTION FLOAT_AS_DOUBLE=’ON’;
SET TEMPORARY OPTION ISOLATION_LEVEL=’1’;
Option Set to
ALLOW_NULLS_BY_DEFAULT OFF
ANSINULL OFF
AUTOMATIC_TIMESTAMP ON
CHAINED OFF
CONTINUE_AFTER_RAISERROR ON
DATE_FORMAT YYYY-MM-DD
DATE_ORDER MDY
ESCAPE_CHARACTER OFF
ISOLATION_LEVEL 1
FLOAT_AS_DOUBLE ON
QUOTED_IDENTIFIER OFF
TIME_FORMAT HH:NN:SS.SSS
TIMESTAMP_FORMAT YYYY-MM-DD HH:NN:SS.SSS
TSQL_HEX_CONSTANT ON
TSQL_VARIABLES ON