ALLBASE/SQL Message Manual (36216-90213)

150 Chapter5
ALLBASE/SQL Error Messages: 2101-2419
ACTION Check the constraint type in SYSTEM.CONSTRAINT and
ensure that the type of the constraint is not "H", for hash.
2281 MESSAGE Maximum number of columns allowed in a
UNIQUE/PRIMARY KEY/FOREIGN KEY is !. (DBERR
2281)
CAUSE The unique or referential constraint exceeds the
maximum number of columns allowed in a unique or
referential constraint.
ACTION Define the unique or referential constraint on columns
within this limit.
2282 MESSAGE UNIQUE/PRIMARY KEY/FOREIGN KEY length exceeds
maximum length (! bytes). (DBERR 2282)
CAUSE Key length exceeds the maximum.
ACTION Define referential constraints which are within the key
length limit specified in the database administrator guide.
2283 MESSAGE Duplicate column name ! in UNIQUE/PRIMARY
KEY/FOREIGN KEY column list. (DBERR 2283)
CAUSE You specified a column name more than once in a column
list of a unique or referential constraint.
ACTION Re-issue the CREATE TABLE statement without
duplicate column names in the UNIQUE/PRIMARY
KEY/FOREIGN KEY column lists.
2284 MESSAGE Invalid data type ! found in column !
specified in a UNIQUE/PRIMARY KEY/FOREIGN KEY
constraint column list. (DBERR 2284)
CAUSE A column found in a unique or foreign key column list is of
an invalid data type.
ACTION Re-issue the statement using columns of the allowed data
types in your constraints.
2285 MESSAGE FOREIGN KEY column ! data type ! doesn't
match data type ! of referenced column.
(DBERR 2285)
CAUSE A pair of corresponding columns in the referencing column
list and referenced column list of a foreign key constraint
have data types which are incompatible for referential
constraints.
ACTION Check the data types of the corresponding columns in your
foreign key constraint declarations and make sure they
are the same data type.
2286 MESSAGE UNIQUE/PRIMARY KEY/FOREIGN KEY column ! not
defined in CREATE/ALTER TABLE. (DBERR 2286)