SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-19
SQL 8221
Cause. The FETCH cursor statement was issued for a cursor that was not opened.
Effect. The statement fails.
Recovery. Open the cursor before reexecuting the FETCH statement.
SQL 8222
Cause. The table or tables had more than one row that satisfied the query, and only
one row is allowed.
Effect. The statement fails.
Recovery. Check the statement and the data to determine whether the statement or
the data is incorrect. If the data is incorrect, correct the data. If the INTO clause is
incorrect, use a cursor to select and fetch the data. Use an INTO clause only when you
expect one row to satisfy the SELECT statement. If the subquery is incorrect,
recompose the SELECT request.
SQL 8223
Cause. The cursor was never declared, or the program is corrupted, or the declared
cursor could not be used to delete or update.
Effect. The statement fails.
Recovery. Check the program for the cursor declaration, open requests, and fetch
requests.
8221 Trying to FETCH an unopened cursor.
8222 More than one row would satisfy a SELECT request with an
INTO clause or a subquery.
8223 The cursor specified in an UPDATE or a DELETE WHERE
CURRENT OF request was not found, is not deletable, or cannot
be used in the present context.