SQL/MP Messages Manual

File-System Messages
HP NonStop SQL/MP Messages Manual—427720-006
16-10
SQL 1039
Cause. The requested update through the cursor is not allowed because the cursor
was declared without the FOR UPDATE clause.
Effect. The update operation fails.
Recovery. Add the FOR UPDATE clause to the DECLARE CURSOR statement; then
preprocess (SQL COBOL programs only), host-language compile, SQL compile, and
run the program again.
For a cursor declared through dynamic SQL, redeclare, reprepare, and reopen the
cursor.
SQL 1040
Cause. An UPDATE WHERE CURRENT OF or DELETE WHERE CURRENT OF
statement was attempted, but the cursor was not positioned on a row.
Effect. The UPDATE or DELETE statement fails.
Recovery. Change the program so that a FETCH operation on the cursor is performed
before any update or delete operation on the cursor. Then preprocess (SQL COBOL
programs only), host-language compile, SQL compile, and run the program again.
SQL 1041
Cause. SQL internal error.
Effect. The operation fails.
Recovery. None. Report the entire message to your service provider.
1039 An SQL UPDATE statement was attempted, but update intent
was not specified when the cursor was declared.
1040 There is no current row. The cursor position is either
before the first row of the set, after the last row, or
between two rows.
1041 SQL internal error.