DB2 Error Code – -683 invalid column type for fieldproc, bit data, sbcs data, or mixed data option, column name

In this post, you’ll learn about the error message -683 invalid column type for fieldproc, bit data, sbcs data, or mixed data option, column name in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-683 invalid column type for fieldproc, bit data, sbcs data, or mixed data option, column name

Reason for the Error

The FIELDPROC, BIT DATA, SBCS DATA, or MIXED DATA option was specified for column ‘column name’.� This is invalid.� Data subtypes can only be specified for character string columns; and field procedures can only be specified for string columns that allow nulls or have no default value.

Solution

Correct the SQL statement.