SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-28
SQL 8259
Cause. The similarity check failed.
Effect. The statement cannot be executed without recompilation. SQL/MP attempts
auto-recompilation.
Recovery. The number of columns must be identical for protection views. For tables,
the execution-time table might have more columns than the compile-time table;
however, for some cases of the use of “*” in an SQL statement, the number of columns
must be identical. To avoid future auto-recompilation, rectify the number of columns in
the execution-time table (protection view).
SQL 8260
Cause. The similarity check failed. The attributes of the column in the execution-time
table (protection view) were not identical to the attributes of the same column in the
compile-time table (protection view).
Effect. The statement cannot be executed without recompilation. SQL/MP attempts
auto-recompilation.
Recovery. To avoid future auto-recompilation, verify that the attributes of the specified
column are the same in the compile-time table and in the execution-time table.
SQL 8261
Cause. The similarity check failed.
Effect. The statement cannot be executed without recompilation. SQL/MP attempts
auto-recompilation.
Recovery. None. Report the entire message to your service provider.
8259 The execution-time table (protection view) value-1 is
not similar to compile-time table (protection view) for the
following reason: The number of columns is different.
8260 The execution-time table (protection view) value-1 is
not similar to compile-time table (protection view) for the
following reason: Attributes of column value-2 are not
identical.
8261 The compile-time table has a column with unknown type.
The error occurred on execution-time table value-1, column
value-2.