DB2 Error Code – -60 invalid type specification : specification-value

In this post, you’ll learn about the error message -60 invalid type specification : specification-value in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-60 invalid type specification : specification-value

Reason for the Error

‘type’ is either LENGTH or SCALE.� ‘spec’ is the specified length or scale.� Length or scale must be specified by an unsigned integer constant and the value must be in the range allowed by the data type.

Solution

Correct the syntax, and reissue the statement.