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-20
SQL 1080
Where column-name is the name of a column of a table.
Cause. You attempted to create a table that has two columns with the same name. If
you name a column “SYSKEY,” duplication can result from the implicit creation by
SQL/MX of a column named SYSKEY to ensure uniqueness for the clustering key.
Effect. The operation fails.
Recovery. Remove duplicate column names and resubmit.
SQL 1081
Where index-name is the name of the index being populated.
Cause. Population of the index failed, either because another concurrent operation
was being performed on the base table or because data could not be loaded into the
index by the Call-level interface (CLI).
Effect. The operation fails.
Recovery. Determine the cause of the CLI failure and resubmit.
SQL 1082
Where constraint-name is the name of a column or table constraint.
Cause. The constraint validation failed, either because a concurrent operation was
being performed on the table or on the referenced table (for a referential integrity
constraint), or data in the table violates the constraint.
Effect. The constraint operation fails.
Recovery. If a concurrent operation is in progress, wait until it has finished and try the
operation again. If data in the table violates the constraint, remove that data and
resubmit.
1080 The create request has duplicate references to column
column-name.
1081 Loading of index index-name failed unexpectedly.
1082 Validation for constraint constraint-name failed
unexpectedly.