SQL/MP Messages Manual

File-System Messages
HP NonStop SQL/MP Messages Manual—427720-006
16-6
recompiling fails to correct the problem, report the entire message to your service
provider.
SQL 1025
Cause. The row or update value that you specified is incompatible with one of the
constraints for the table.
Effect. The update or insert operation fails.
Recovery. Correct the SQL statement and reissue the statement.
SQL 1026
Cause. An update or insert operation on a view tried to produce a row that would not
reside in the view. The view was defined with the WITH CHECK OPTION, which
prohibits using the view to insert or update rows outside the view.
Effect. The insert or update operation fails.
Recovery. Either correct the values in the INSERT or UPDATE statement to comply
with the view's definition, or re-create the view omitting the WITH CHECK OPTION
clause in the view definition.
SQL 1027
Cause. Stated in the error message.
Effect. The operation fails.
Recovery. Use the TMF subsystem to recover the object, or report the entire message
to your service provider.
1025 The supplied row or update value violates one of the
constraints for the table.
1026 The selection expression on an SQL view has been
violated.
1027 The disk process encountered a bad SQL label or tree of
labels.