-420 THE VALUE OF A STRING ARGUMENT WAS NOT ACCEPTABLE TO THE function-name FUNCTION

Explanation

A string argument did not conform to the requirements of the function. For example, a character string passed to the DECIMAL function did not conform to the rules for forming an SQL integer or decimal constant.

If the error is issued for an implicit or explicit cast, the function-name token contains the name of the cast's target data type. For implicit cast where a character-string or graphic-string value is compared with a numeric value, Db2 implicitly converts the string value to DECFLOAT(34) so the function-name function will have a DECFLOAT value.