SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
3-36
SQL 1141
Where file-name is the Guardian file name of a partition of object.
Where error-number is a Guardian file system error.
Cause. An ALTER TABLE or ALTER INDEX operation encountered a file system error.
Effect. The operation fails.
Recovery. See the Guardian Procedure Errors and Messages Manual to diagnose
and correct the problem.
SQL 1142
Cause. Internal error.
Effect. NonStop SQL/MX is unable to perform the requested operation.
Recovery. None. Contact your service provider.
SQL 1143
Where,
constraint-name is the name of a column constraint or table constraint.
referencing-table-name is the table on which the constraint is being added.
referenced-table-name is the table specified in the FOREIGN KEY clause.
statement-text is a query.
Cause. You attempted to add a referential integrity constraint that is violated by rows
already in the table.
Effect. The operation fails.
1141 Label file-name for object could not be accessed. File
system error error-number.
1142 Because it is not audited, this table cannot have a
column added that is declared NOT NULL, or has a CHECK,
UNIQUE, PRIMARY KEY, or FOREIGN KEY constraint.
1143 Validation for constraint constraint-name failed;
incompatible data exists in referencing base table
referencing-table-name and referenced base table referenced-
table-name. To display the data that violates the constraint,
please use the following DML statement: statement-text.