SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual—523730-004
3-50
Where lock-name is the ANSI name of the DDL lock object that is associated with the
utility operation.
Cause. You attempted to drop an object that a utility command is using.
Effect. The operation fails.
Recovery. Wait until the utility operation has finished, and then retry the DROP
operation.
SQL 1251
Where value is the default value that was specified for column-name.
Where column-name is the name of the column in the table.
Cause. A CREATE TABLE or ALTER TABLE...ADD COLUMN specified a default
value with a scale greater than the scale of the column.
Effect. The scale of the default value is set to that of the column; extra digits to the
right are discarded.
Recovery. None. This is an warning message only.
SQL 1252
Where index-name is the name of an existing unpopulated index.
Cause. An existing index that is not populated has been chosen for a unique or
primary constraint, which is not allowed.
Effect. The operation fails.
Recovery. Populate the index and resubmit.
SQL 1254
Cause. You attempted to specify both the unique and primary key constraints or
multiple unique constraints on the same set of columns, which is not allowed.
Effect. The operation fails.
1251 The extra insignificant digits of default value value
are truncated to match the scale of the data type of column
column-name.
1252 The existing index index-name to be used by a unique or
primary constraint has not been populated. Please populate
the index and then try to add the constraint again.
1254 Duplicate unique constraints are not allowed with same
set of columns.