ALLBASE/SQL Message Manual (36216-90213)

140 Chapter5
ALLBASE/SQL Error Messages: 2101-2419
The same index name was used in creating indexes on two
tables with the same owner.
ACTION Use the syntax DROP INDEX
IndexName FROM [ Owner .]
TableName to specify which table's index should be
dropped.
2223 MESSAGE Index !.! not found. (DBERR 2223)
CAUSE A non-existent index was specified in the DROP INDEX
statement without an associated table.
ACTION Check your spelling. If you still receive this error, ask your
database administrator to check the SYSTEM.INDEX
view to make sure that the specified index does exist.
2224 MESSAGE ! !.! must have same owner as table !.!.
(DBERR 2224)
CAUSE Different owners were given for the named INDEX,
CONSTRAINT, or RULE and the named table, or the
default table owner was different from the specified
INDEX, CONSTRAINT, or RULE owner in the CREATE
INDEX, DROP INDEX, DROP CONSTRAINT, CREATE
RULE, or DROP RULE statement.
ACTION If both owners were specified, check your spelling. If the
table owner was not specified, either specify one or drop
the specification of the INDEX, CONSTRAINT, or RULE
owner. If you still receive this error, ask your database
administrator to check the SYSTEM.INDEX view,
SYSTEM.CONSTRAINT view, or SYSTEM.RULE view to
determine the correct owner.
2225 MESSAGE Out of disc space for all TempSpaces. (DBERR
2225)
CAUSE There is not enough space in the device to support your
sorting operation.
ACTION Use a different device or contact your database
administrator to add more space to the current device.
2226 MESSAGE Location name must be fully qualified with
group and account name. (DBERR 2226)
CAUSE The location name you specified in the CREATE
TEMPSPACE statement was not fully qualified.
ACTION Issue the CREATE TEMPSPACE statement again,
specifying a location name that includes both group and
account name.
2227 MESSAGE Duplicate SCHEMA !. (DBERR 2227 )
CAUSE There are existing objects already owned by the
AuthorizationName specified.