HP NonStop SQL/MX, Messages Manual

Page: 81 / 752

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual — 640324-001
3- 55
SQL 1250
Where
object-name
is the ANSI name of the object named in the DROP command.
Where
operation-type
is the type of utility operation.
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.
1250 DROP cannot be performed on object object-name because a
utility operation ( operation-type) associated with DDL_LOCK
lock-name is currently running.
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.