DB2 Error Code – -688 incorrect data returned from field procedure, column name, msgno

In this post, you’ll learn about the error message -688 incorrect data returned from field procedure, column name, msgno in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-688 incorrect data returned from field procedure, column name, msgno

Reason for the Error

Unexpected data returned from field procedure for column ‘column name’.� For more information see ‘msgno’.

Solution

Correct the field procedure so that it returns values that are consistent with their descriptions.