ALLBASE/SQL Message Manual (36216-90213)

Chapter 5 143
ALLBASE/SQL Error Messages: 2101-2419
condition in an IF or WHILE statement or the
expression in a parameter or variable
assignment. Procedure execution terminated.
(DBERR 2238)
CAUSE An error occurred in evaluating the condition or
expression.
ACTION Refer to the accompanying error message for additional
information.
2239 MESSAGE Procedure !.! not found. (DBERR 2239)
CAUSE The procedure you specified in the statement does not
exist in the DBEnvironment.
ACTION Check your spelling of the procedure name and the
procedure's owner name against the content of the
CATALOG.PROCEDURE view. If you still receive this
error, ask your database administrator to check the
SYSTEM.PROCEDURE view to make sure the specified
procedure does exist.
2240 MESSAGE Procedure !.! already exists. (DBERR 2240)
CAUSE The procedure you specified in the CREATE
PROCEDURE statement already exists in the
DBEnvironment.
ACTION Create the procedure with a different name and/or owner
name.
2241 MESSAGE Too many parameter values provided for
procedure !.!. (DBERR 2241)
CAUSE In the EXECUTE PROCEDURE statement, you provided
a greater number of parameter values than the number of
parameters in the procedure.
ACTION Check the procedure specification or the parameter
descriptions in SYSTEM.PARAMETER. Reissue the
EXECUTE PROCEDURE statement, providing no more
parameter values than the number in the procedure.
2242 MESSAGE Error(s) occurred processing statement !
during procedure creation/validation. (DBERR
2242)
CAUSE One or more errors occurred while processing an SQL
statement in a procedure. The statement was not stored as
an invalid section, since it can never be validated. The
procedure was not created.
ACTION Use the statement number in the message to determine
which procedure statement generated the error. Refer to
the accompanying messages for more information.