In this post, you’ll learn about the error message -171 the data type, length, or value of argument nn of function-name is invalid in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-171 the data type, length, or value of argument nn of function-name is invalid
Reason for the Error
Either the data type, the length or the value of argument ‘nn’ of scalar function ‘function-name’ is incorrect.
Solution
Correct the invocation of the function, and reissue the statement. If the encoding scheme is EBCDIC or ASCII, a possible reason for this error is that a character argument was specified for a built-in function that expects a graphic argument, or a graphic argument was specified for a built-in function that expects a character argument. The UNICODE encoding scheme supports the mixing of character and graphic arguments, but EBCDIC and ASCII do not.
