SQL/MP Messages Manual
SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-25
SQL 8250
Cause. The similarity check failed. The similarity check was not enabled for the
execution-time table (protection view).
Effect. The statement cannot be executed without recompilation. SQL/MP attempts
auto-recompilation.
Recovery. To avoid future auto-recompilation, enable the similarity check on the table
(protection view) using the ALTER command.
SQL 8251
Cause. The similarity check failed.
Effect. The statement cannot be executed without recompilation. SQL/MP attempts
auto-recompilation.
Recovery. To avoid future auto-recompilation, verify that the WHERE clauses of the
compile-time and execution-time protection views are identical.
SQL 8252
Cause. The similarity check failed.
Effect. The statement cannot be executed without recompilation. SQL/MP attempts
auto-recompilation.
Recovery. To avoid future auto-recompilation, verify that the execution-time table has
the same file organization as the compile-time table.
8250 Execution-time table (protection view) value-1 is not
similar to compile-time table (protection view) for the
following reason: The similarity check is not enabled.
8251 Execution-time protection view value-1 is not similar to
the compile-time protection view for the following reason:
The WHERE clauses are different.
8252 Execution-time table (protection view) value-1 is not
similar to compile-time table (protection view) for the
following reason: The execution-time table has a different
file organization than the compile-time table.