Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual—640324-001
3-37
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
Where column-name is the column in table-name.
Where table-name is the name of the table.
Where 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.
Effect. The operation fails.
Recovery. Correct the value first-key-string to be a type that is compatible with
the type of column column-name and resubmit.
SQL 1145
Where catalog-name is the name of an SQL/MX catalog.
Cause. NonStop SQL/MX reserves certain catalog names for its own use.
Effect. The operation fails.
Recovery. See the SQL/MX Reference Manual for reserved names. Change
catalog-name to a name that is not reserved and resubmit.
SQL 1146
Where object-name is the name of the object being requested.
Where object-type is the type of object required for the DDL statement issued.
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).
1145 The catalog name catalog-name is reserved for SQL/MX
matadata.
1146 Object object-name could not be altered because it is
not a object-type.
To Next Page