HP Neoview Messages, Manual

Page: 122 / 400

dependent-object
is the name of a dependent object of the target table, such as an index,
after trigger, materialized view, or referential integrity constraint.
Cause
An INSERT, UPDATE, or DELETE operation into a table with dependent objects was
attempted when the NO ROLLBACK transaction setting is ON.
Effect
Compilation of the statement fails.
Recovery
If you intend to use NO ROLLBACK, drop the dependent object. Otherwise, either
turn OFF the NO ROLLBACK transaction setting or remove the WITH NO ROLLBACK clause
from the SQL statement.
SQL 3233
3233 This type of UPDATE is not allowed when NO ROLLBACK transaction
setting is in effect.
Cause
On a positioned UPDATE or an embedded UPDATE statement, an UPDATE operation
that included the STREAM clause, the SET ON ROLLBACK clause, and nonconstant values
in the SET expression was attempted when the NO ROLLBACK transaction setting was ON.
Effect
Compilation of the statement fails.
Recovery
If you intend to use NO ROLLBACK, remove the conflicting clause. Otherwise,
either turn OFF the NO ROLLBACK transaction setting, or remove the WITH NO ROLLBACK
clause from the SQL statement.
SQL 3234
3234 This type DELETE is not allowed when NO ROLLBACK transaction setting
is in effect.
Cause On a positioned DELETE or an embedded DELETE statement, a DELETE operation
that included the STREAM clause and SET ON ROLLBACK clause was attempted when the
NO ROLLBACK transaction setting is ON.
Effect Compilation of the statement fails.
Recovery If you intend to use NO ROLLBACK, remove the conflicting clause. Otherwise,
either turn OFF the NO ROLLBACK transaction setting, or remove the WITH NO ROLLBACK
clause from the SQL statement.
SQL 3235
3235 Invalid value value specified for AUTOABORT timeout interval.
value
is an invalid, user-specified value.
Cause The timeout interval value specified for AUTOABORT in a SET TRANSACTION
statement is invalid.
Effect
The SET TRANSACTION statement fails.
Recovery
Specify a valid value. For a description values that are valid, see the Neoview SQL
Reference Manual.
SQL 3236
3236 Transaction access mode, autoabort interval, or NO ROLLBACK was
specified, and query contains at least one SQL/MP table. Transaction
specification will be ignored.
Cause Transaction access mode, autoabort interval, or NO ROLLBACK was specified; and
the query contains at least one SQL/MP table.
Effect
Compilation of the statement fails.
Recovery
Retry the statement by specifying the NO ROLLBACK OFF setting, the
AUTOABORT RESET setting, and the READ WRITE access mode.
122 Parser and Compilation Messages (3000 Through 3999)