Ansicht
Dokumentation

SQL0846 - Attributes not valid for IDENTITY column or sequence. ( OS/400 )

SQL0846 - Attributes not valid for IDENTITY column or sequence. ( OS/400 )

ROGBILLS - Synchronize billing plans   General Material Data  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0846
Attributes not valid for IDENTITY column or sequence.

Message Long Text :

Cause . . . . . : Error &6 occurred for an IDENTITY column or sequence. For an IDENTITY column, &2 in schema &3 is the name of the table. For a sequence, &2 in &3 is the name of the sequence.
-- Code 1 -- The data type of an IDENTITY column or sequence is not INTEGER, BIGINT, SMALLINT, or DECIMAL or NUMERIC with a scale of zero. An IDENTITY column that is DECIMAL or NUMERIC must have a precision less than or equal to 31.
-- Code 2 -- The value specified for START WITH, INCREMENT BY, MINVALUE, or MAXVALUE is outside the range for the data type specified.
-- Code 3 -- The value specified for MINVALUE is larger than the value specified for MAXVALUE.
-- Code 4 -- The value specified for CACHE is not valid. The minimum value for CACHE is 2.
-- Code 7 -- A sequence can only be altered to a distinct type if the current data type is a built-in data type and it is promotable to the source data type of the distinct type. If the current data type is a distinct type, it can only be changed to its source data type.
Recovery . . . : Specify valid attributes for the IDENTITY column or sequence. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


TXBHW - Original Tax Base Amount in Local Currency   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3245 Date: 20240328 Time: 231257     sap01-206 ( 2 ms )