-574   THE SPECIFIED DEFAULT VALUE OR IDENTITY ATTRIBUTE VALUE CONFLICTS WITH THE DEFINITION OF COLUMN column-name

A value specified for a column is not valid.

column-name

The name of the column.

Possible reasons for this error include:

• 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.
• A floating-point constant is specified and the column is not a floating point data type.
• A decimal constant is specified and non-zero digits would be truncated when assigned to the column.
• The value is more than 255 bytes, including quotation marks for strings, introducer characters such as the X for a hex constant, fully qualified function names, and parentheses.
• Either the USER, or SESSION_USER, or CURRENT SQLID special register is specified and the length attribute of the character string column is not sufficient to store a value that is 8 characters when the value is expressed in CCSID 37.
• A system-generated cast function was specified and the column is not defined with a user-defined distinct type.
• A function was specified that is not supported. A function can be specified only 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.
• A value with non-zero scale was specified for the START WITH or INCREMENT BY option of an identity column with the DECIMAL data type.
• A decimal floating point (DECFLOAT) constant is specified. A decimal floating point cannot be restricted to zero scale numbers and, as such, may not be used in IDENTITY columns.
• WITH DEFAULT is specified using a value other than NULL for a LOB column without INLINE LENGTH attribute.
• The length of the default value is greater than the INLINE LENGTH attribute of the LOB column.
• A default value was specified for a timestamp with time zone column but the default value does not contain a time zone.