SQL/MP Messages Manual

SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual427720-006
3-42
SQL 1259
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Use the VERIFY utility to determine why the table is not valid. Contact your
system manager about validating the object, and reissue the statement.
SQL 1260
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Correct the statement by specifying the PARTONLY clause, and reissue
the statement.
SQL 1261
Cause. The partition name did not have the same subvolume and file name as the
other partition (table or index name).
Effect. The statement fails.
Recovery. Correct the partition name and reissue the statement.
SQL 1262
Cause. The existing data in the table does not satisfy the constraint. However, the
constraint has been applied to the file label. Hence the constraint is dropped.
Effect. The statement fails.
Recovery. Identify the rows that do not satisfy the constraint by issuing a SELECT
statement that contains the negation of the constraint. Delete or modify the identified
rows so that the remaining rows satisfy the constraint. Enter the CREATE
CONSTRAINT DEFERRED statement again.
1259 The underlying table is not valid so that this operation
could not be performed.
1260 A PARTONLY clause must be specified with this operation.
1261 The subvolume and file names of value-1 must be the same
as those of the other partitions, value-2; only the system
and volume names can differ.
1262 The constraint is dropped as the data in the table does
not satisfy the constraint.