ALLBASE/SQL Message Manual (36216-90213)

Chapter 5 141
ALLBASE/SQL Error Messages: 2101-2419
ACTION Make sure the AuthorizationName specified is neither an
owner of existing objects in the DBEnvironment nor a
grantor of authority on existing objects. To check
ownership,query SYSTEM.TABLEandSYSTEM.GROUP.
To check authorities, query SYSTEM.TABAUTH and
SYSTEM.COLAUTH.
2228 MESSAGE Duplicate column ! found in joined table.
(DBERR 2228)
CAUSE With an explicit three or more table join, a result table
(which participates in a subsequent join clause) has been
produced and it has more than one column with the same
column name. This same column name is either specified
as a join column in the "ON
SearchCondition " clause of
the explicit join, or if a NATURAL...JOIN has been
specified, the column has been chosen by ALLBASE/SQL
as a join column.
ACTION When writing a three or more table join with explicit join
syntax make sure that for any single result table
participating in a join, there are no duplicate column
names which will be named as a join column. To ensure
this, make each join clause a NATURAL...JOIN or a
JOIN...USING (
ColumnList ), except for the final join,
which may contain these types or a JOIN...ON
SearchCondition3 clause. Otherwise, ensure that each
join clause is a JOIN...ON
SearchCondition3 clause.
2229 MESSAGE Duplicate column ! found in USING clause of
JOIN. (DBERR 2229)
CAUSE There is more than one column with the same name in the
USING (
ColumnList ) clause of an explicit join.
ACTION Remove the duplicate column name from the USING
(
ColumnList ) clause of the explicit join.
2230 MESSAGE Maximum number of parameters (!) exceeded in
procedure !.!. (DBERR 2230)
CAUSE The number of parameters you specified in the CREATE
PROCEDURE statement was greater than the maximum
number allowed.
ACTION Issue the CREATE PROCEDURE statement again,
limiting the number of parameters to 255 or fewer.
2231 MESSAGE Procedure parameter data type may not be
a LONG data type. (DBERR 2231)
CAUSE You specified a LONG data type as the parameter data
type in a CREATE PROCEDURE statement.
ACTION Issue the statement again, specifying only a valid