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.
