Chapter 5 Database Options
205
Existing procedures must be recreated before changing option
Any existing procedures that contain %-style comments must be recreated
before you change the option setting; otherwise, the procedures will fail to
load.
The Sybase Central code editor does not highlight %-style comments. If you
wish to have your comments highlighted in the Sybase Central editor, you
should use one of the other comment delimiters.
PRECISION option
Specifies the maximum number of digits in the result of any decimal
arithmetic.
Integer, with a maximum of 127
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
30
Precision is the total number of digits to the left and right of the decimal
point. The "SCALE option" on page 210 specifies the minimum number of
digits after the decimal point when an arithmetic result is truncated to the
maximum PRECISION.
Multiplication, division, addition, subtraction, and aggregate functions can
all have results that exceed the maximum precision.
For example, when a DECIMAL(8,2) is multiplied with a DECIMAL(9,2),
the result could require a DECIMAL(17,4). If PRECISION is 15, only 15
digits will be kept in the result. If SCALE is 4, the result will be a
DECIMAL(15,4). If SCALE is 2, the result will be a DECIMAL(15,2). In
both cases, there is a possibility of overflow.
PREFETCH option
The PREFETCH option acts as a toggle allowing you to turn fetching on and
off.
ON, OFF
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
ON
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
To Next Page
Loading...