SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-15
SQL 8202
Cause. An object's definition changed since the statement was last SQL compiled.
SQL/MP attempted to recompile the statement.
Effect. The statement succeeds if the recompilation succeeds, else the SQLCA will
have an appropriate error message.
Recovery. See the SQLCA for the error condition indicating why compilation failed,
and correct the condition. 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.
SQL 8203
Cause. An ALTER TABLE... NO AUDIT statement was executed after the statement
was SQL compiled.
Effect. An attempt to recompile the statement is made.
Recovery. After an ALTER TABLE... NO AUDIT operation, recompile all application
programs that reference the table (NOTE: altering the AUDIT attribute does not cause
program invalidation). Alternatively, use a CONTROL TABLE statement to access the
table with a SYNCDEPTH value of 0.
SQL 8204
Cause. Can be one of the following:
1. A DDL operation preempted the open operation for a table
2. SQL/MP could not access the node that contains the table
3. The volume containing the table was not available
Effect. The statement fails.
Recovery. Correct the problem and reissue the command. New opens should remain
in effect unless they are preempted by a DDL operation. If a FETCH cursor operation
receives this error, the cursor is also closed, and the application must open the cursor
again to use the cursor.
8202 Because of a label timestamp mismatch on file value-1,
automatic recompilation will be attempted, if allowed.
8203 Because of invalid use of file system subset calls for
file value-1, automatic recompilation will be attempted, if
allowed.
8204 An existing OPEN failed on table value-1.