SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Executor Messages (8000 through 8999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
10-8
Effect. The UPDATE/DELETE WHERE CURRENT statement is invalid.
Recovery. Perform another FETCH then an UPDATE/DELETE.
SQL 8107
Cause. A self-referencing INSERT is executed in a transaction when AUTOCOMMIT
is set to OFF and the compiler has chosen the DP2 Locks method.
Effect. The INSERT operation fails and no rows are inserted.
Recovery. Ensure that the compiler chooses the Blocking Plan Operator method by
setting the CQD, BLOCK_TO_PREVENT_HALLOWEEN to ON.
SQL 8140
Where name is the name of the file.
Where number is the line number.
Cause. You set an environmental variable to test cancel processing.
Effect. The statement was canceled.
Recovery. Execute the statement again after first resetting the environmental variable.
SQL 8141
Cause. You set an environmental variable to test error handling.
Effect. The operation fails.
Recovery. Recompile and reexecute the statement, after first resetting the
environmental variable.
8107 Self-referencing INSERT statement without blocking
operator is not allowed with AUTOCOMMIT OFF.
Note. The DP2 Locks method cannot be used from embedded SQL programs written in C,
C++, and Cobol for self-referencing INSERT statements. Since these statements are executed
with AUTOCOMMIT OFF, an SQL error 8107 is returned. Hence, it is neccessary that the
compiler use the Blocking Plan Operator method by setting the CQD,
BLOCK_TO_PREVENT_HALLOWEEN to ON.
8140 The statement was canceled, to test cancel processing.
File name at line number.
8141 An error was artificially injected, to test error
handling. File name at line number.