I am using DB2 QMF 9.1 on my company's mainframe. We also have QMF for Windows version 8.1 fixpack 14, same problem is happening there.
I have a table where I have stored very simple data from previous queries using the COUNT function. One row of data, col1 = 285; col2 = 217. In a query, I am trying a very simple math function:
So it should be 285/217 = 1.3133. However, db2 is giving me a result of 1.3. When I multiply by 100, the answer is 130.0. That answer is incorrect. It seems to only want to read to the first decimal place. I have also tried using the DECIMAL command to expand to two decimal places. but then I get an error message 'Numeric value is outside allowable range for column.'
I was able to change the data in the [T_GROUP_NL_X3]table to store it with two decimals; however, this has no effect when I try to do the calculation.