| |
- Causa
- THE SPECIFIED DEFAULT VALUE OR IDENTITY ATTRIBUTE VALUE CONFLICTS WITH THE DEFINITION OF COLUMN column-name
column-name is not valid for one of the following reasons:
- 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 quotes for strings, introducer characters such as the X for a hex constant, fully
qualified function names, and parentheses.
- Either the USER or CURRENT SQLID special register is specified and the length attribute of the character string data type is less than 8.
- 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 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.
- WITH DEFAULT is specified with a value other than NULL for a LOB column.
- 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ção do sistema
- The SQL statement cannot be executed.
- Resposta ao Desenvolvedor
- Specify a default value that is valid for the definition of the column.
SQLSTATE: 42894
© Copyright IBM Corp.
|
| |
