ALLBASE/SQL Message Manual (36216-90213)

Chapter 6 199
ALLBASE/SQL Error Messages: 2420-2795
2784 MESSAGE DDL statement not allowed in PREPARE REPEAT
command. (DBERR 2784)
CAUSE Data definition language statements (CREATE TABLE,
CREATE INDEX, DROP TABLE, etc.) are not allowed in a
PREPARE command with the REPEAT option.
ACTION Do not use the REPEAT option for DDL commands.
2785 MESSAGE The starting position is invalid for the
SUBSTRING function. (DBERR 2785)
CAUSE The StartPosition parameter of the SUBSTRING function
is less than 1 or greater than the length of the
SourceString.
ACTION Change the StartPosition parameter to a value greater
than 0, and less than or equal to the length of the
SourceString parameter.
2786 MESSAGE The substring length is invalid for the
SUBSTRING function. (DBERR 2786)
CAUSE The Length parameter of the SUBSTRING function is less
than 1 or greater than the length of the SourceString
parameter.
ACTION Change the Length parameter to a value greater than 0,
and less than or equal to the length of the SourceString
parameter.
2787 MESSAGE Length of item ! in select list exceeds that
of corresponding procedure result column.
(DBERR 2787)
CAUSE An item in the select list in a procedure SELECT
statement with no INTO clause has a length greater than
that specified for the corresponding procedure result
column in the WITH RESULT clause of the CREATE
PROCEDURE statement.
ACTION Re-issue the CREATE PROCEDURE statement, either
omitting the WITH RESULT clause, or ensuring that all
multiple row result sets returned from the procedure are
compatible with the format specified.
2788 MESSAGE USING Clause is required for output dynamic
parameters. (DBERR 2788)
CAUSE You tried to execute a prepared EXECUTE PROCEDURE
statement with output dynamic parameters, but no output
variables were provided in the USING clause of an
EXECUTE or CLOSE statement.
ACTION Issue the EXECUTE or CLOSE statement again with the
USING clause, specifying output variables for output