"(ShowCase ODBC)(OS/400) SQL Negative Scale not valid."
This occurs when running a query containing a result column with a divide, expecting a value like .88.
Use a FLOAT wrapper to help Query build correct resultant data type for the divide, as in FLOAT(EXPRESSION)/FLOAT(EXPRESSION) and it must appear on both sides of the equation.
FLOAT(((a/b)-(c+d+e+f+g+h))) / FLOAT((a/b))
NOTE: The float command enables Query to recognize and complete equations by allowing more than the designated decimal places.
Without the float wrapper, an equation that returned a number such as 1.23434643216 would only be seen as 1.
Still have questions? We can help. Submit a case to Technical Support.