Ansicht
Dokumentation

SQL0190 - Attributes of column &3 in &1 in &2 not compatible. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : SQL0190
Attributes of column &3 in &1 in &2 not compatible.

Message Long Text :

Cause . . . . . : The attributes specified for column &3 in &1 in &2 are not compatible with the attributes of the existing column. Either the data type, the length, or the clause is not valid.
-- A numeric column cannot be changed to a type that is not numeric.
-- A character column cannot be changed to a DATE, TIME, TIMESTAMP, or a numeric column.
-- A DATE, TIME, or TIMESTAMP column can only be changed to a column of the same type.
-- A character column cannot be changed to DBCS-only column.
-- A character, graphic, DataLink, or Unicode column cannot be changed to a column with an incompatible CCSID.
-- A binary column cannot be changed to a column that is not binary.
-- A column that is not binary cannot be changed to a binary column.
-- A DataLink column cannot be changed to a column with a shorter length.
-- A column can be changed to a user-defined type if the type is promotable to the new type. A column that is a user-defined type cannot be changed to a different type.
-- Columns cannot be changed to or from a DataLink, a ROWID, or an XML data type.
-- The length of a column that allows null values cannot be greater than 32765 for fixed-length character or fixed-length binary, 32739 for varying-length character or varying-length binary, 16382 for fixed-length graphic, and 16369 for varying-length graphic. The length of a DataLink column cannot be greater than 32717. The length of a binary LOB, character LOB, or XML column cannot be greater than 2147483647. The length of a double-byte LOB column cannot be greater than 1073741823. The length of a DBCS-open column cannot be less than 4.
-- Identity attributes can only be specified for a column defined as an identity column. DROP NOT NULL cannot be specified for an identity column.
-- DROP DEFAULT can only be specified if a default value is defined for the existing column and the column does not have NOT NULL as the null attribute.
-- DROP FIELDPROC can only be specified if a field procedure is defined for the existing column.
-- ADD FIELDPROC can only be specified if a field procedure is not defined for the existing column.
-- Only the CCSID can be altered for an XML column.
Recovery . . . : Specify attributes that are compatible with column &3. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL Application Log Documentation   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.

Length: 3265 Date: 20240420 Time: 150618     sap01-206 ( 3 ms )