ALLBASE/SQL Message Manual (36216-90213)

Chapter 4 123
ALLBASE/SQL Error Messages: 746-2100
parameter, aggregate function, TID function, long column
function, or date/time conversion function involving a
column reference.
ACTION Rewrite your EXECUTE PROCEDURE statement,
eliminating the illegal element from the expression in the
actual parameter.
1139 MESSAGE The OUTPUT option is not allowed for
parameters that contain an expression in the
EXECUTE PROCEDURE statement. (DBERR 1139)
CAUSE You attempted to use the OUTPUT option with a
parameter that contains an expression in an EXECUTE
PROCEDURE statement within an application program.
ACTION Check the actual parameters of your EXECUTE
PROCEDURE statement and eliminate the illegal use of
the OUTPUT option.
1140 MESSAGE The language clause is not valid with a
non-character parameter or variable in the
CREATE PROCEDURE statement. (DBERR 1140)
CAUSE You specified a language for a parameter, variable, or
result of a non-character data type in a CREATE
PROCEDURE statement.
ACTION Reissue the CREATE PROCEDURE statement, omitting
the language clause for any parameter, variable, or result
of a non-character data type.
1141 MESSAGE No value was provided for a named list
parameter in the EXECUTE PROCEDURE statement.
(DBERR 1141)
CAUSE You specified the name of a parameter in a named
parameter list, but you did not specify a value for the
parameter.
ACTION Check the parameter list included in the EXECUTE
PROCEDURE statement, and ensure that you supply a
value for each parameter. Then reissue the EXECUTE
PROCEDURE statement.
1142 MESSAGE Named list and ordered list parameters cannot
be mixed in the EXECUTE PROCEDURE statement.
(DBERR 1142)
CAUSE You specified one or more named parameters together with
one or more ordered parameters in the same EXECUTE
PROCEDURE statement. A parameter list must be either
an ordered list or a named list and cannot mix parameters
of both types.
ACTION Check the parameter list included in the EXECUTE