-574 THE SPECIFIED DEFAULT VALUE OR IDENTITY ATTRIBUTE VALUE CONFLICTS WITH THE DEFINITION OF COLUMN column-name
Explanation
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.
System action
The statement cannot be processed.
Programmer response
Specify a default value that is valid for the definition of the column, and reissue the statement.
SQLSTATE
42894