Sybase Adaptive Server Anywhere - Page 998

System and catalog stored procedures
980
If you wish to change the default behavior, it is recommended that you create
new procedures and alter your LOGIN_PROCEDURE option to point to
these new procedures.
♦ Here is the text of the sp_tsql_environment procedure:
create procedure dbo.sp_tsql_environment()
begin
if db_property(’IQStore’)=’OFF’ then
-- ASA datastore
set temporary option AUTOMATIC_TIMESTAMP=’ON’
end if;
set temporary option ANSINULL=’OFF’;
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 FLOAT_AS_DOUBLE=’ON’;
set temporary option ON_TSQL_ERROR=’CONTINUE’;
set temporary option ISOLATION_LEVEL=’1’;
set temporary option DATE_FORMAT=’YYYY-MM-DD’;
set temporary option TIMESTAMP_FORMAT=’YYYY-MM-DD
HH:NN:SS.SSS’;
set temporary option TIME_FORMAT=’HH:NN:SS.SSS’;
set temporary option DATE_ORDER=’MDY’;
set temporary option ESCAPE_CHARACTER=’OFF’
end
Example