DB2 SQL-Error: -419
SQLState: 42911
Short Description: 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 3 of DB2 SQL Reference. System action: The statement cannot be executed. No data was retrieved, updated, or deleted. Programmer response: Examine the precision and scale of all columns that might have participated in a decimal division. Note that an integer or small integer value might have been converted to decimal for this calculation. A value of YES for field MINIMUM DIVIDE SCALE on installation panel DSNTIPF specifies that the scale of the result of a decimal division is never less than 3.