Alphabetical list of options
210
RI_TRIGGER_TIME option
Controls the relative timing of referential integrity checks and trigger actions.
BEFORE, AFTER
Can be set for the PUBLIC option only. DBA authority is required to set this
option.
AFTER
The option can be set to either BEFORE or AFTER. When it’s set to AFTER,
referential integrity actions are executed after the UPDATE or DELETE.
Only the PUBLIC setting can be used; any other setting is ignored.
SCALE option
Specifies the minimum number of digits after the decimal point when an
arithmetic result is truncated to the maximum PRECISION.
Integer, with a maximum of 127.
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
6
Multiplication, division, addition, subtraction, and aggregate functions can
all have results that exceed the maximum precision. See "PRECISION
option" on page 205 for an example.
SQL_FLAGGER_ERROR_LEVEL option
Controls the response to any SQL that is not part of a specified set of
SQL/92.
E, I, F, or W
W
This option flags any SQL that is not part of a specified set of SQL/92 as an
error.
The allowed values of level are as follows:
♦
E Flag syntax that is not entry-level SQL/92 syntax
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...