Ansicht
Dokumentation

SQL0574 - Column or sequence attribute is not valid. ( OS/400 )

CPI1466 during Backup   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.


Message : SQL0574
Column or sequence attribute is not valid.

Message Long Text :

Cause . . . . . : Either the DEFAULT value or identity attribute value for column &3 in &1 in &2 is not valid, a sequence attribute value for sequence &1 in &2 is not valid, or an assigned value for cycle column &3 is not valid.
For a DEFAULT value, the incorrect value may either be specified in this statement or it may already be defined for the column and is not compatible with the new attributes specified on the ALTER TABLE statement.
The values must conform to the following rules:
-- The DEFAULT value must be compatible with the data type of the column. A floating-point constant can only be a default value for a floating-point or DECFLOAT column. A DECFLOAT constant can only be a default value for a DECFLOAT column.
-- The DEFAULT value must not be too long for the column.
-- If the column is defined as a date, time, or timestamp the DEFAULT value must be a valid string representation of that type.
-- If the DEFAULT value is defined as the value of the USER special register, the column must be defined as a CHAR or VARCHAR and the length attribute must be greater than or equal to 18.
-- The CCSID of the DEFAULT value must be compatible with the CCSID of the column.
-- The DEFAULT value for a column that is a user-defined type must either be promotable to the source type or must be cast to the user-defined type using the cast function for the type.
-- A DEFAULT value cannot be specified for a DataLink or an XML column or SQL variable.
For an identity column or a sequence, the values specified for the START WITH, INCREMENT BY, MINVALUE, MAXVALUE, and RESTART WITH options must have a scale of zero.
For a recursive common table expression cycle column name, the assignment value must be a character string with a length of one.
Recovery . . . : Change the value to one that is valid for the column or sequence. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   General Material Data  
This documentation is copyright by IBM.

Length: 3246 Date: 20240424 Time: 062219     sap01-206 ( 3 ms )