ALLBASE/SQL Message Manual (36216-90213)

Chapter 5 149
ALLBASE/SQL Error Messages: 2101-2419
a foreign key. (DBERR 2276)
CAUSE You attempted to revoke an authority which is currently
depended on by the specified user, class or group (directly
or indirectly) to authorize a foreign key.
ACTION Re-issue the revoke with CASCADE specified, or have
your DBA or the owner of the foreign key remove the table
in which the foreign key resides, or remove the foreign key
(using DROP TABLE or DROP CONSTRAINT) and then
reissue the revoke.
2277 MESSAGE Table !.! does not have a primary key, or
number of columns in primary key does not
match number in foreign key. (DBERR 2277)
CAUSE The table specified in a REFERENCES clause without a
column list has no PRIMARY KEY to use as an implicit
column list, or the number of columns in the PRIMARY
KEY does not match the number specified in the foreign
key list.
ACTION Specify a column list with the table referenced, or check
the number of columns in the primary key of the table
referenced.
2278 MESSAGE Referenced column list does not match any
UNIQUE or PRIMARY KEY constraint in table
!.!. (DBERR 2278)
CAUSE The column list given for a table in a REFERENCES
clause does not match any candidate key defined on the
table.
ACTION Check the order of the columns, as they must exactly
match the order of the candidate key columns. Specify a
referenced column list in the same order as some
candidate key in the referenced table.
2279 MESSAGE User ! does not have ! authority on needed
columns of table/view !.!. (DBERR 2279)
CAUSE You do not have the authority to access the columns of a
table.
ACTION Check with the database administrator for the needed
authority, sign on as a user with the required authority.
2280 MESSAGE PRIMARY KEY/UNIQUE constraint with HASH index
can not be dropped. (DBERR 2280)
CAUSE You attempted to drop a constraint that was used in the
HASH ON CONSTRAINT clause in the CREATE TABLE
statement. These constraints cannot be dropped without
dropping the whole table.