ALLBASE/SQL Message Manual (36216-90213)

120 Chapter4
ALLBASE/SQL Error Messages: 746-2100
integer value.
ACTION Use an integer value for the ReturnStatus in the RETURN
statement.
1123 MESSAGE Indicator variables are not allowed with
parameters or local variables used in a
stored procedure statement. (DBERR 1123)
CAUSE You attempted to include an indicator variable with a
parameter declaration or with a local variable in the
CREATE PROCEDURE statement.
ACTION Rewrite your CREATE PROCEDURE statement,
eliminating indicator variables.
1124 MESSAGE Element in Boolean expression is not allowed
in current procedure statement. (DBERR 1124)
CAUSE The following elements are not allowed in the
Condition
of IF and WHILE statements in a procedure: aggregate
functions, TID functions, long column functions, column
references, DATETIME conversion functions involving
columns references, and subquery expressions.
ACTION Rewrite your CREATE PROCEDURE statement,
eliminating the illegal elements from the Condition.
1125 MESSAGE Undefined parameter, local variable or
cursor. (DBERR 1125)
CAUSE The parameter, variable, or cursor is referenced inside a
procedure without first being defined.
ACTION Define the parameter, local variable, or cursor before
referencing it in the CREATE PROCEDURE statement.
1126 MESSAGE Doubly defined parameter, local variable or
cursor. (DBERR 1126)
CAUSE You defined the parameter, local variable, or cursor more
than once.
ACTION Check your parameter list, local variable declaration, or
cursor definition and reissue the CREATE PROCEDURE
statement.
1127 MESSAGE Built-in-variable is not allowed in an SQL
statement. (DBERR 1127)
CAUSE You used a built-in variable in an SQL statement. Built-in
variables can only be used in non-SQL statements inside a
procedure.
ACTION Check the expressions in the procedure's SQL statements,
and reissue the CREATE PROCEDURE statement.
1128 MESSAGE A local variable or parameter is required for