ALLBASE/SQL Message Manual (36216-90213)

166 Chapter5
ALLBASE/SQL Error Messages: 2101-2419
length greater than the maximum allowed.
ACTION Reduce the minimum tuple length of the table and reissue
the statement.
2409 MESSAGE Length of index ! on table !.! exceeds !
bytes. (DBERR 2409)
CAUSE The index you attempted to create exceeds the maximum
key length.
ACTION Recreate your index using a column or combination of
columns that is less than the maximum number of bytes.
2410 MESSAGE Tuple exceeded maximum length. (DBERR 2410)
CAUSE The maximum tuple length of 4,000 bytes has been
exceeded.
ACTION Check your input source (e.g. load file) and the original
CREATE TABLE statement to make sure that each tuple
is less than or equal to 4,000 bytes long.
2411 MESSAGE Number of sort columns (!) exceeds maximum !.
(DBERR 2411)
CAUSE The ORDER BY, GROUP BY, or DISTINCT clause of the
SELECT statement specifies a number of columns which
exceeded the maximum allowable.
ACTION Issue the command again, specifying no more than the
maximum number of sort columns. Refer to the
ALLBASE/SQL Reference Manual for additional
information on the SELECT statement.
2412 MESSAGE Index exceeded maximum length. (DBERR 2412)
CAUSE The maximum index length of 1024 bytes has been
exceeded
or
the ORDER BY or GROUP BY clause uses a column
greater than 1024 bytes.
ACTION Check your input source (e.g. load file) and the original
CREATE INDEX command to make sure that each index
entry is less than or equal to 1024 bytes long
or
reduce the size of the column used by the ORDER BY or
GROUP BY to less than 1010 bytes.
2413 MESSAGE Number of boolean factors in predicate
expression exceeds maximum (!). (DBERR 2413)
CAUSE The number of factors in the WHERE clause exceeds the
maximum allowed.