ALLBASE/SQL Message Manual (36216-90213)
Chapter 6 197
ALLBASE/SQL Error Messages: 2420-2795
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