Neoview Database Administrator's Guide (R2.3)

Example 2
12.3450 rounded to scale 2 = 12.34
12.3350 rounded to scale 2 = 12.34
12.3451 rounded to scale 2 = 12.35
12.3360 rounded to scale 2 = 12.34
12.3330 rounded to scale 2 = 12.33
• Precision and Scale of Arithmetic Operations
The maximum precision is limited to 18. If an arithmetic computation exceeds this precision,
Neoview SQL returns an overflow error. The scale of the result is computed using the
semantics of your previous DBMS.
Multiplication
op1 * op2
Result scale = op1scale + op2scale
Division
op1 / op2
Result scale = MAXOF(op1, op2)
Examples
10*6 => 60 10/6 => 2
10.0*6 => 60.0 10.0/6 => 1.7
10.00*6.0=> 60.000 10.00/6 => 1.67
• Ignore Duplicate Keys
The “Ignore Duplicate Keys” feature simulates SET Table support and provides the same
semantics with one exception: Rows with duplicate keys are ignored during insert operations.
To disable this feature, contact HP Support for assistance in setting the
IGNORE_DUPLICATE_KEYS default to 'OFF.'
Mode_Special_2 123