| |
- Causa
- THE DECIMAL DIVIDE OPERATION IS INVALID BECAUSE THE RESULT WOULD HAVE A NEGATIVE SCALE.
The decimal division is invalid because it will result in a negative scale.
The formula used internally to calculate the scale of the result for decimal division is explained in Chapter 2 of
DB2 SQL Reference.
- Ação do sistema
- The statement cannot be executed.
No data was retrieved, updated, or deleted.
- Resposta ao Desenvolvedor
- Examine the precision and scale of all columns that may have participated in a decimal division.
Note that an integer or small integer value may have been converted to decimal for this calculation.
SQLSTATE: 42911
© Copyright IBM Corp.
|
| |
