DB2 SQL-Error: -574
SQLState: 42894
Short Description: THE SPECIFIED DEFAULT VALUE OR IDENTITY ATTRIBUTE VALUE CONFLICTS WITH THE DEFINITION OF COLUMN C E SQL A START WITH INCREMENT BY DECIMAL S T SQL P S
The DEFAULT value specified for column-name is not valid for one of the following reasons: v The value is not assignable to the column because the constant does not conform to the format for a constant of that data type, or the value has the incorrect length or precision. v A floating-point constant is specified and the column is not a floating point data type v A decimal constant is specified and non-zero digits would be truncated when assigned to the column v The value is more than 255 bytes, including quotes for strings, introducer characters such as the X for a hex constant, fully qualified function names, and parentheses. v Either the USER or CURRENT SQLID special register is specified and the length attribute of the character string data type is less than 8. v A system-generated cast function was specified and the column is not defined with a user-defined distinct type v A function was specified that is not supported. A function may only be specified when the data type is a distinct type, and in this case the specified function must be one of the system-generated cast functions associated with this distinct type. v WITH DEFAULT is specified with a value other than NULL for a LOB column.