Neoview Messages Manual (Volume 1) (R2.4)

Effect The operation fails.
Recovery See the Neoview SQL Reference Manual for row size limit calculations. Change the
column definitions and reissue the statement.
SQL 1141
1141 Label file-name for object could not be accessed. File system error
error-number.
file-name
is the HP Neoview platform file name of a partition of object.
error-number
is a Neoview platform file-system error.
Cause An ALTER TABLE or ALTER INDEX operation encountered a file-system error.
Effect The operation fails.
Recovery For information about file-system errors, see Chapter 20 (page 353).
SQL 1142
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.
Cause Internal error.
Effect The HP Neoview database is unable to perform the requested operation.
Recovery None. Contact the GMCSC.
SQL 1143
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.
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.
Recovery Run the query statement-text to see the rows that violate the referential
constraint. Either change those rows or change the referential constraint definition and resubmit.
SQL 1144
1144 A quoted string was expected in first key clause for column
column-name on table table-name, but the value detected is
(first-key-string).
column-name is the column in table-name.
table-name
is the name of the table.
first-key-string
is the erroneous value used in the FIRST KEY clause for
column-name.
Cause In a CREATE TABLE statement, a value specified as first key is not a quoted string,
but the type of the column for which this value is specified is one of the character data types.
36 Data Definition Language (DDL) Messages (1000 Through 1999)