ALLBASE/SQL Message Manual (36216-90213)

174 Chapter6
ALLBASE/SQL Error Messages: 2420-2795
ACTION Before dropping the DBEFileSet, drop the DBEFiles then
remove them. Remember that the DBEFiles must be
empty before they can be dropped.
2501 MESSAGE DBEFileSet has no DBEFiles. (DBERR 2501)
CAUSE You created a table in an empty DBEFileSet and then
tried to INSERT into that table.
ACTION ADD a DBEFile to the DBEFileSet before attempting an
INSERT statement.
2502 MESSAGE ! space exhausted in DBEFileSet !. (DBERR
2502)
CAUSE This message can have several meanings as follows:
1. All the space is exhausted in a DBEFileset if no
expandable DBEFiles are available.
2. All fixed-length DBEFiles in the DBEFileSet have run
out of space, and all expandable DBEFiles have been
fully expanded.
The first parameter is the setting for the DBEFile's TYPE
attribute. Valid settings are INDEX, TABLE, and MIXED.
ACTION Add new DBEFiles of the appropriate type to the
DBEFileSet. If space has been exhausted in the
System.DBEFileSet during a query, try adding more
tempspace and more contiguous physical disk space.
2503 MESSAGE DBEFile not empty. (DBERR 2503)
CAUSE You attempted to REMOVE a non-empty DBEFile from its
DBEFileSet.
ACTION The DBEFile must be empty before it can be removed from
the DBEFileSet.
2505 MESSAGE DBEFile size must be between ! and ! pages.
(DBERR 2505)
CAUSE The file size you specified in the CREATE DBEFILE
statement was not within the valid range.
ACTION Issue the CREATE DBEFILE statement again, specifying
a valid file size.
2506 MESSAGE TempSpace file size limit must be between !
and ! pages. (DBERR 2506)
CAUSE The file size you specified in the CREATE TEMPSPACE
statement was not within the valid range.
ACTION Issue the CREATE TEMPSPACE statement again,
specifying a valid file size.
2507 MESSAGE DBEFile must be empty or new type must be