ALLBASE/SQL Message Manual (36216-90213)

176 Chapter6
ALLBASE/SQL Error Messages: 2420-2795
!. (DBERR 2513)
CAUSE You specified a number of primary pages for the hash in
the CREATE TABLE statement which was not within the
valid range.
ACTION Issue the CREATE TABLE statement again, specifying a
valid number of primary pages.
2514 MESSAGE Hash key uniqueness or UNIQUE/PRIMARY KEY
constraint violated. (DBERR 2514)
CAUSE You tried to insert a duplicate key value into a column
used in a unique hash structure, which might be
supporting a unique constraint.
ACTION Issue the INSERT statement again without the duplicate
row.
2515 MESSAGE DBEFile is currently associated with a
DBEFileSet. (DBERR 2515)
CAUSE You tried to DROP a DBEFile which was associated with a
DBEFileSet
or
you tried to ADD a DBEFile to a DBEFileSet which
already is associated with another DBEFileSet.
ACTION You must REMOVE the DBEFile from the DBEFileSet
before it can be dropped
or
you must REMOVE the DBEFile from the DBEFileSet
with which it is currently associated before you can ADD it
to a different DBEFileSet.
2516 MESSAGE This table already has a clustering index.
(DBERR 2516)
CAUSE When you use the CREATE INDEX statement, no more
than one index per table can have the clustering attribute.
ACTION Drop the existing clustering index or create the new index
without the clustering attribute.
2518 MESSAGE DBEFile in use for hash. (DBERR 2518)
CAUSE You tried to DROP or ALTER a DBEFile that is allocated
for hash table data.
ACTION First DROP the hash table. Then, the DBEFile may be
DROPped or ALTERed.
2519 MESSAGE Exceeded maximum number of DBEFiles for hash
space (!). (DBERR 2519)
CAUSE The DBEFileSet specified for the hash table does not