HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Error Messages (Continued)
2765 MESSAGE DDL commands disabled. (DBERR 2765)
CAUSE The DDL Enabled flag in the DBECon file was set to
NO when you attempted to execute DDL (data
definition language) commands.
ACTION STOP the DBEnvironment, use the SQLUtil ALTDBE
command to set the DDL Enabled flag to YES, then
START the DBEnvironment and proceed with data
definition.
----------------------------------------------------------------------------
2766 MESSAGE Unable to revalidate section while DDL commands
are disabled. (DBERR 2766)
CAUSE The DDL Enabled flag in the DBECon file was set to
NO when ALLBASE/SQL encountered an invalid stored
section.
ACTION STOP the DBEnvironment, use the SQLUtil ALTDBE
command to set the DDL Enabled flag to YES, then
START the DBEnvironment and run the application
again.
----------------------------------------------------------------------------
2768 MESSAGE Current tuple does not satisfy the predicate in
the cursor definition. (DBERR 2768)
CAUSE After you fetched the data, the data was updated by
another transaction and no longer satisfies your
cursor definition.
ACTION No action is necessary.
----------------------------------------------------------------------------
2769 MESSAGE Cursor !.!(!) is not updatable. (DBERR 2769)
CAUSE You tried to REFETCH or UPDATE using a cursor that
is not updatable.
ACTION Make sure you declare the cursor FOR UPDATE in the
DECLARE CUSOR statement.
----------------------------------------------------------------------------
2770 MESSAGE INSERT rejected: FORMAT II INSERT cannot insert
a table into itself. (DBERR 2770)
CAUSE The table you specified as the target table in the
INSERT statement was the same as one of the tables
in the embedded SELECT statement.
ACTION Modify your command specifying a different target
table or remove the target table from the embedded
SELECT statement.
----------------------------------------------------------------------------
2771 MESSAGE KEEP CURSOR with NOLOCKS is not supported on
NON-UPDATABLE CURSOR. (DBERR 2771)
CAUSE You specified the KEEP CURSOR WITH NOLOCKS option
for a cursor which was declared as SELECT...ORDER
BY or SELECT DISTINCT. These operations need to
build temporary tables, and if KEEP CURSOR WITH
NOLOCKS is in effect, the consistency between
permanent and temporary tables cannot be guaranteed
between transactions.
ACTION Revise the program to open the cursor with the KEEP
CURSOR WITH LOCKS option.
----------------------------------------------------------------------------
2772 MESSAGE Cursor !.!(!) containing SUBQUERY is not allowed
in the REFETCH command. (DBERR 2772)
CAUSE You attempted to perform a REFETCH on a cursor
containing a subquery.
ACTION REFETCH cannot be done on cursors containing
subqueries. Either remove the subquery from the
cursor, or do not perform REFETCH on that cursor.
----------------------------------------------------------------------------
2773 MESSAGE Multiple-rows operation is NOT allowed in the
REFETCH command. (DBERR 2773)
CAUSE You specified more than one record in the REFETCH
statement.
ACTION Make sure to specify only one record for the
REFETCH statement.
----------------------------------------------------------------------------
2774 MESSAGE Escape character in LIKE pattern must be followed
by escape character, underscore, or percent.
(DBERR 2774)
CAUSE There is an escape character in a LIKE predicate
pattern that is not followed by an escape
character, underscore, or percent.
ACTION Change the pattern to a legal pattern.
----------------------------------------------------------------------------
2775 MESSAGE Escape character must be a single character.
(DBERR 2775)
CAUSE You specified a multi-character string for the
escape pattern, or passed in a host variable
containing more than a single character.
ACTION Correct the specification of the escape string to
be a single character, or make sure that the host
variable is set to blanks after the escape
character.
----------------------------------------------------------------------------
2776 MESSAGE Dynamic parameters as both operands of a single
binary operator disallowed. (DBERR 2776)
CAUSE You specified dynamic parameters for both operands
of an arithmetic or comparison operator.
ACTION Modify your statement to not specify dynamic
parameters for both operands of the arithmetic or
comparison operator.
----------------------------------------------------------------------------
2777 MESSAGE Dynamic parameter as the operand of a unary
arithmetic operator disallowed. (DBERR 2777)
CAUSE You specified a dynamic parameter in a NULL
predicate or a minus sign is specified in front of
the dynamic parameter.
ACTION Modify your statement to not contain a dynamic
parameter in a NULL predicate nor a minus sign in
front of a dynamic parameter.
----------------------------------------------------------------------------
2778 MESSAGE Dynamic parameter in the SELECT list disallowed.
(DBERR 2778)
CAUSE You specified a dynamic parameter in the SELECT
list.
ACTION Modify your statement to not contain a dynamic
parameter in a SELECT list.
----------------------------------------------------------------------------
2779 MESSAGE TID data type is not supported. (DBERR 2779)
CAUSE You specified a column of TID data type in the
CREATE TABLE or ALTER TABLE statement. There is no
TID data type.
ACTION Check and modify the statement.
----------------------------------------------------------------------------
2780 MESSAGE Psuedotable can not be updated. (DBERR 2780)
CAUSE You attempted to perform an update on a system
pseudotable.
ACTION Check that the correct table name has been
specified.
----------------------------------------------------------------------------
2781 MESSAGE Illegal reference to TID function in group
operation. (DBERR 2781)
CAUSE Within a single query block, you cannot specify the
GROUP BY clause when using the TID function in the
select list.
ACTION Check and modify the command.
----------------------------------------------------------------------------
2782 MESSAGE TID function is not allowed for the pseudotable
(!.!). (DBERR 2782)
CAUSE The parameter in the TID function is a system
pseudotable.
ACTION Check and modify the command.
----------------------------------------------------------------------------
2783 MESSAGE TID function is not allowed for the non-updatable
view (!.!). (DBERR 2783)
CAUSE The parameter in the TID function is not an
updatable view.
ACTION Check and modify the command.
----------------------------------------------------------------------------
[REV BEG]
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.
[REV END]
----------------------------------------------------------------------------
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 dynamic parameters in the prepared
statement.
----------------------------------------------------------------------------
2790 MESSAGE CANNOT use DROP PARTITION on DEFAULT partition.
(DBERR 2790)
CAUSE You attempted to drop the DEFAULT partition.
ACTION This partition cannot be dropped. Its partition
number can be changed with the START DBE NEWLOG
statement.
----------------------------------------------------------------------------
2791 MESSAGE Cannot CREATE PARTITION !. (DBERR 2791)
CAUSE You attempted to create a partition named NONE or
DEFAULT. This partition name cannot be used since
it refers to the nonexistent partition.
ACTION No partition can be created with this name in the
CREATE PARTITION statement.
----------------------------------------------------------------------------
2792 MESSAGE Comment text for LOG COMMENT must have data type
CHAR or VARCHAR. (DBERR 2792)
CAUSE The value for a log comment was not a character
value.
ACTION Check the type of the value and be sure it is CHAR
or VARCHAR.
----------------------------------------------------------------------------
2793 MESSAGE Cannot LOG COMMENT when AUDIT LOG not enabled.
(DBERR 2793)
CAUSE You specified a LOG COMMENT statement in a
DBEnvironment without audit logging or with audit
logging disabled.
ACTION Enable AUDIT LOG for the DBEnvironment or refrain
from issuing LOG COMMENT on the DBEnvironment.
----------------------------------------------------------------------------
[REV BEG]
2794 MESSAGE Cannot open log scan on AUDIT CHECKPOINT only
DBEnvironment. (DBERR 2794)
CAUSE Unable to open the log scan on the AUDIT
CHECKPOINT.
ACTION Enable AUDIT LOG for the DBEnvironment, not for
AUDIT CHECKPOINT.
[REV END]
----------------------------------------------------------------------------
2800 MESSAGE Table's language is not compatible with DBE's
language. (DBERR 2800)
CAUSE The language you specified for the table is neither
the same as DBEnvironment's language, nor
NATIVE-3000.
ACTION Make sure the table's language is either
NATIVE-3000 or the same as the DBEnvironment's
language.
----------------------------------------------------------------------------
2801 MESSAGE Column's language not compatible table/DBE's
language. (DBERR 2801)
CAUSE The language you specified for the column is
neither table/DBEnvironment's language nor
NATIVE-3000.
ACTION Make sure the column's language is either the same
as table/DBEnvironment's language or NATIVE-3000.
----------------------------------------------------------------------------
2802 MESSAGE Procedure result language is not compatible with
procedure/DBEnvironment language. DBERR 2802)
CAUSE A language other than that of the DBEnvironment or
n-computer was specified for a procedure result.
ACTION Re-issue the CREATE PROCEDURE statement, either
omitting the language clause, or specifying either
the DBEnvironment language or n-computer.
----------------------------------------------------------------------------
2803 MESSAGE Procedure language is not compatible with
DBEnvironment language. (DBERR 2803)
CAUSE The language you specified for the procedure was
neither the DBEnvironment language nor NATIVE-3000.
ACTION Issue the CREATE PROCEDURE statement again,
specifying either the DBEnvironment language or
NATIVE-3000 for the procedure, or specifying no
procedure language.
----------------------------------------------------------------------------
2804 MESSAGE Parameter language is not compatible with
procedure/DBEnvironment language. (DBERR 2804)
CAUSE The language you specified for the parameter was
neither the procedure/DBEnvironment language nor
NATIVE-3000.
ACTION Issue the CREATE PROCEDURE statement again,
specifying either the procedure/DBEnvironment
language or NATIVE-3000 for the parameter, or
specifying no parameter language.
----------------------------------------------------------------------------