HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Error Messages (Cont.)
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
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.
ACTION Check the SELECT portion of your DECLARE CURSOR
statement to make sure there is no INTO clause, and
reissue the CREATE PROCEDURE statement. Use the
INTO clause in the FETCH statement.
----------------------------------------------------------------------------
1134 MESSAGE Local variable data type is invalid. (DBERR
1134)
CAUSE You attempted to use a non-integer local variable
or parameter in a SAVEPOINT, ROLLBACK WORK TO
SAVEPOINT, or SET TIMEOUT statement in a procedure.
ACTION Correct the data type for the local variable or
parameter and reissue the CREATE PROCEDURE
statement.
----------------------------------------------------------------------------
1135 MESSAGE A local variable/host variable is not allowed in
an inner query block. (DBERR 1135)
CAUSE You attempted to use a local or host variable in a
nested query block or in any query block in a UNION
other than the first UNION block.
ACTION Remove the illegal variable reference in the query.
----------------------------------------------------------------------------
1136 MESSAGE The number of parameters defined exceeds the
maximum of 255. (DBERR 1136)
CAUSE You attempted to specify more than the maximum of
255 parameters in a CREATE PROCEDURE or EXECUTE
PROCEDURE statement.
ACTION Reissue the CREATE PROCEDURE or EXECUTE PROCEDURE
statement using 255 or fewer parameters.
----------------------------------------------------------------------------
1137 MESSAGE The expression in a variable or parameter
assignment statement contains an element that is
not allowed in a stored procedure. (DBERR 1137)
CAUSE You used one of the following elements, which are
not allowed in the expression of an assignment
statement in a procedure: column reference,
subquery, dynamic parameter, aggregate function,
TID function, long column function, or date/time
conversion function involving a column reference.
ACTION Reissue the CREATE PROCEDURE statement ,
eliminating the illegal elements from the
expression.
----------------------------------------------------------------------------
1138 MESSAGE The expression in an actual parameter contains an
element that is not allowed in the EXECUTE
PROCEDURE statement. (DBERR 1138)
CAUSE The following elements are not allowed in an
expression in an actual parameter in the EXECUTE
PROCEDURE statement: column reference, subquery,
dynamic 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
PROCEDURE statement, and ensure that you use a
consistent parameter type in the parameter list.
Then reissue the EXECUTE PROCEDURE statement.
----------------------------------------------------------------------------
1143 MESSAGE Multiple values provided for single parameter in
the EXECUTE PROCEDURE statement. (DBERR 1143)
CAUSE You used the same parameter name more than once in
a named parameter list in the EXECUTE PROCEDURE
statement.
ACTION Correct the EXECUTE PROCEDURE statement, making
sure that each parameter name is assigned only one
value. Then reissue the EXECUTE PROCEDURE
statement.
----------------------------------------------------------------------------
1144 MESSAGE The number of result columns defined exceeds the
maximum num of 1024. (DBERR 1144)
CAUSE You specified more that 1024 result columns in a
CREATE PROCEDURE statement.
ACTION Reissue the CREATE PROCEDURE statement, specifying
no more than 1024 result columns.
----------------------------------------------------------------------------
1145 MESSAGE Dynamic parameters are not allowed in procedure
statements. (DBERR 1145)
CAUSE You included a dynamic parameter in a statement
inside a parameter.
ACTION Reissue the CREATE PROCEDURE statement, omitting
any dynamic parameter.
----------------------------------------------------------------------------
1146 MESSAGE The WITH RESULT clause is allowed only for a
procedure returning results. (DBERR 1146)
CAUSE You included the WITH RESULT clause in a CREATE
PROCEDURE statement, but the procedure returns no
result sets.
ACTION Reissue the CREATE PROCEDURE statement, omitting
the WITH RESULT clause.
----------------------------------------------------------------------------
1147 MESSAGE DEFAULT clause is not allowed for an OUTPUT ONLY
parameter. (DBERR 1147)
CAUSE You provided a default value for an OUTPUT ONLY
parameter in the CREATE PROCEDURE statement.
ACTION Reissue the CREATE PROCEDURE statement, either
omitting the default value, or specifying OUTPUT
rather than OUTPUT ONLY.
----------------------------------------------------------------------------
1150 MESSAGE Host variables not allowed in CREATE RULE.
(DBERR 1150)
CAUSE You defined a RULE containing a host variable.
ACTION Check the syntax and remove the host variable from
your CREATE RULE statement.
----------------------------------------------------------------------------
1151 MESSAGE Duplicate statement type specified in CREATE
RULE. (DBERR 1151)
CAUSE You defined a RULE with duplicate statement types.
ACTION Check the syntax and remove the duplicate statement
type from your CREATE RULE statement.
----------------------------------------------------------------------------
1152 MESSAGE TID function disallowed in CHECK constraint or
RULE. (DBERR 1152)
CAUSE A RULE or CHECK constraint contains a TID function.
ACTION Check the syntax and remove the TID function from
your CREATE RULE statement or CHECK constraint.
----------------------------------------------------------------------------
1153 MESSAGE RETURN clause not permitted in EXECUTE PROCEDURE
of CREATE RULE. (DBERR 1153)
CAUSE You included a RETURN clause in the EXEC PROCEDURE
clause of a CREATE RULE statement.
ACTION Remove the RETURN clause from the EXEC PROCEDURE
clause.
----------------------------------------------------------------------------
1154 MESSAGE OUTPUT parameters not permitted in EXECUTE
PROCEDURE of CREATE RULE. (DBERR 1154)
CAUSE You included a parameter defined for OUTPUT in the
EXECUTE PROCEDURE clause of a CREATE RULE
statement.
ACTION Remove the key word OUTPUT from the EXECUTE
PROCEDURE clause.
----------------------------------------------------------------------------
1155 MESSAGE Negative Hexstring is not allowed. (DBERR 1155)
CAUSE You attempted to enter a negative hexstring.
ACTION Remove the minus sign from the hexstring and
reissue the statement.
----------------------------------------------------------------------------
1156 MESSAGE Duplicate ISOLATION LEVEL clause defined. (DBERR
1156)
CAUSE You have more than one IDOLATION LEVEL clause in
the SET TRANSACTION or SET SESSION statement.
ACTION Check the specified SET TRANSACTION or SET SESSION
statement.
----------------------------------------------------------------------------
1157 MESSAGE Duplicate PRIORITY clause defined. (DBERR 1157)
CAUSE You specified the PRIORITY clause more than once in
the SET TRANSACTION or SET SESSION statement.
ACTION Check the specified SET TRANSACTION or SET SESSION
statement.
----------------------------------------------------------------------------