SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-18
SQL 8217
Cause. You tried to EXECUTE a dynamic SELECT statement.
Effect. The statement fails.
Recovery. Declare a cursor for the prepared SELECT statement, and reissue the
statement.
SQL 8218
Cause. An OPEN, FETCH or CLOSE operation was attempted on a non-cursor
statement. For example, in dynamic SQL, the cursor was declared for a prepared
statement other than a SELECT statement.
Effect. The cursor operation fails.
Recovery. Prepare only SELECT statements for use with cursor operations.
SQL 8219
Cause. The CLOSE cursor statement attempted to close a cursor that was already
closed or had never been opened.
Effect. The cursor remains closed.
Recovery. Delete the CLOSE statement.
SQL 8220
Cause. The OPEN cursor statement attempted to open a cursor that was already
open.
Effect. The cursor is not reopened; execution continues.
Recovery. No recovery is necessary.
8217 The statement being executed requires a cursor.
8218 A cursor operation has been attempted on a non-cursor
statement.
8219 Trying to CLOSE a cursor that is already closed or was
never opened.
8220 Trying to OPEN a cursor that is already opened.