Chapter 5 Database Options
187
This option reports a syntax error for those queries containing outer joins that
have ambiguous syntax due to the presence of duplicate correlation names on
a null-supplying table.
The following join clause illustrates the kind of query that is reported.
( R left outer join T , T join S on ( C1 ) )
where C1 is a condition. If the option is set to ON, this query is interpreted as
follows.
( R left outer join T on ( C1 ) ) join S on ( C2 )
where C1 and C2 are conditions.
FIRE_TRIGGERS option
Controls whether triggers are fired in the database.
ON, OFF
ON
When set to ON, triggers are fired. When set to OFF, no triggers are fired,
including referential integrity triggers (such as cascading updates and
deletes). Only a user with DBA authority can set this option. The option is
overridden by the
-gf command-line option, which turns off all trigger firing
regardless of the FIRE_TRIGGERS setting.
This option is relevant when replicating data from Adaptive Server
Enterprise to Adaptive Server Anywhere, because all actions from Adaptive
Server Enterprise transaction logs are replicated to Adaptive Server
Anywhere, including actions carried out by triggers.
FLOAT_AS_DOUBLE option
Controls the interpretation of the FLOAT keyword.
ON, OFF
OFF
ON for Open Client and JDBC connections
The FLOAT_AS_DOUBLE option makes the FLOAT keyword behave like
Adaptive Server Enterprise’s FLOAT keyword when a precision is not
specified.
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...