ALLBASE/SQL Message Manual (36216-90213)

Chapter 5 153
ALLBASE/SQL Error Messages: 2101-2419
ACTION Modify the query to have a CHAR or VARCHAR data type
column on the LIKE predicate.
2297 MESSAGE FOREIGN KEY column ! data type DECIMAL(!,!)
doesn't match PRIMARY KEY data type
DECIMAL(!,!). (DBERR 2297)
CAUSE You entered a value in the referencing column which has a
different precision and scale than the precision and scale
of the PRIMARY KEY referenced column.
ACTION Check the precision and scale of the PRIMARY KEY and
change the value entered in the referencing column to
match it.
2300 MESSAGE User ! does not have ! authorization. (DBERR
2300)
CAUSE The DBEUserID under which the command was executed
does not have the authority (DBA, RESOURCE, or
CONNECT) to execute the command.
ACTION Contact your database administrator to get the required
authority or sign on as a user who does have the required
authority.
2301 MESSAGE User ! does not have ! authority on !.!.
(DBERR 2301)
CAUSE The DBEUserID does not have the required table or view
authority to execute the command.
ACTION Contact your database administrator to get the required
authority or sign on as a user who does have the required
authority.
2302 MESSAGE User ! does not have ! authority on column
!.!.!. (DBERR 2302)
CAUSE You do not have the specified authority needed to access
the column. UPDATE is needed in the UPDATE
statement, or REFERENCES is needed in the CREATE
TABLE statement.
ACTION Contact your database administrator to get the required
authority or sign on as a user who does have the required
authority.
2303 MESSAGE User ! does not have OWNER or DBA authority.
(DBERR 2303)
CAUSE The command requires either OWNER or DBA authority.
ACTION Refer to the ALLBASE/SQL Database Administration
Guide and the ALLBASE/SQL Reference Manual for
statements requiring special authority. Contact your
database administrator to get the required authority.