Neoview SQL Reference Manual (R2.5)

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 533