SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-16
SQL 8205
Cause. The system failed to purge data of a temporary table. See the SQLCA for the
error returned by the file system.
Effect. The statement fails.
Recovery. Check the file system error in the SQLCA to determine the cause. The
program can display the file system error by using the SQLCADISPLAY procedure
described in the SQL/MP programming manual for the host language in which the
program is written. Report the entire message to your service provider.
SQL 8206
Cause. A FETCH, UPDATE, or DELETE operation on a cursor was executed within a
user-defined TMF transaction that was different from the transaction within which the
cursor was opened.
Effect. The statement fails.
Recovery. Verify that the FETCH, UPDATE, or DELETE operations on a cursor
execute within the same TMF transaction in which the cursor was opened.
SQL 8207
Cause. A DDL operation changed the AUDIT attribute of a table. Although this does
not normally invalidate programs, certain SQL statements (for example, statements
that are executed in parallel) need to be recompiled.
Effect. Automatic recompilation is attempted. If automatic recompilation is not allowed,
the statement fails.
Recovery. If a static SQL statement failed, SQL compile the program file again or
change the AUDIT attribute back to its original value. No recovery is necessary for
dynamic SQL.
8205 Error in deallocating space of a temporary table.
8206 Transaction ID mismatch detected on the operation on
value-1.
8207 A change in the AUDIT file attribute of table value-1
invalidated this statement. Automatic recompilation will be
attempted, if allowed.