SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-23
SQL 8235
Cause. A file system error occurred. The statement might have referred to an object
that did not exist at recompilation time.
Effect. The statement fails.
Recovery. Display all errors reported in the SQLCA to determine why recompilation
failed. 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. Correct these conditions and rerun the program. If an
internal error occurred, report the entire message to your service provider.
SQL 8236
Cause. A file system error occurred for the index. The SQLCA contains the error.
Effect. The statement will be recompiled (if recompilation is allowed) to use another
access path and reexecuted.
Recovery. SQL/MP attempts recompilation and reexecution of the program. If the
recompilation fails, or the program is compiled with NORECOMPILE option, an
appropriate error message is reported in the SQLCA.
SQL 8237
Cause. The SQL/MP executor received an error (set in the SQLCA) and chose to
reexecute the statement using a different access strategy.
Effect. The new access strategy is executed.
Recovery. No recovery is necessary. This message is informational only.
8235 Unable to recompile statement.
8236 An index used to access data was not available. An
attempt to recompile the SQL statement using an alternate
access path will be made.
8237 The statement was recompiled.