Start of change

-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

End of change