ALLBASE/SQL Message Manual (36216-90213)

Chapter 4 121
ALLBASE/SQL Error Messages: 746-2100
this SQL statement in a stored procedure.
(DBERR 1128)
CAUSE You used the SELECT, FETCH, or REFETCH statement
inside a procedure without specifying a local variable or
parameter.
ACTION Reissue the CREATE PROCEDURE statement including
the appropriate local variable or parameter along with the
SELECT, FETCH, or REFETCH.
1129 MESSAGE OUTPUT option is allowed only for host
variables in EXECUTE PROCEDURE. (DBERR 1129)
CAUSE You attempted to use the OUTPUT option without
specifying a host variable in the EXECUTE PROCEDURE
statement in an application program.
ACTION Check the actual parameters of your EXECUTE
PROCEDURE statement and eliminate the illegal use of
the OUTPUT option.
1130 MESSAGE The LONG data type is not allowed for a
parameter or local variable in a stored
procedure. (DBERR 1130)
CAUSE You attempted to declare a parameter or local variable
with the LONG data type in the CREATE PROCEDURE
statement.
ACTION Reissue the CREATE PROCEDURE statement without
the LONG parameter or variable declaration.
1131 MESSAGE No LABEL is allowed for this procedure
statement. (DBERR 1131)
CAUSE No label is allowed in the DECLARE
Variable
statement, the WHENEVER statement, or compound
statements.
ACTION Remove the illegal label and reissue the CREATE
PROCEDURE statement.
1132 MESSAGE Cursor name must be a single identifier.
(DBERR 1132)
CAUSE You attempted to qualify a cursor name with an owner or
module name.
ACTION Delete the cursor name qualification in the specified
statement and reissue the CREATE PROCEDURE
statement.
1133 MESSAGE No INTO clause is allowed in the SELECT
statement of a DECLARE CURSOR. (DBERR 1133)
CAUSE You attempted to use an INTO clause inside a cursor
declaration in a procedure.