SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-41
SQL 8501
Cause. The statement that was being released, or for which a cursor name was being
defined, held a cursor that was open.
Effect. The statement fails.
Recovery. Close the cursor and reissue the statement.
SQL 8502
Cause. The cursor name being declared was previously declared for another
statement in the same procedure.
Effect. The statement fails.
Recovery. Choose a cursor name that is not already in use, and reissue the
statement.
SQL 8503
Cause. The statement PREPARE:P.:S... created a different SQL statement for each
distinct value supplied in the host variable S. Too many such values have been used.
Effect. The PREPARE statement fails.
Recovery. Reduce the number of SQL statements used in the program.
SQL 8510
Cause. One of the required parameters for SQLCAGETINFOLIST was not supplied.
Effect. The call fails.
Recovery. Correct the call to specify all required parameters.
8501 Statement has open cursor.
8502 Cursor name already declared in this procedure.
8503 Too many SQL statements have been created using a
PREPARE statement.
8510 A required parameter to SQLCAGETINFOLIST is missing.