SQL/MX 3.1 Messages Manual (H06.23+, J06.12+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.1 Messages Manual—663849-001
3-76
Effect. The operation fails.
Recovery. Resubmit the statement when the locking contention has cleared.
SQL 1601
Where col-name is the IDENTITY column name.
Where table-name is the table that contains the IDENTITY column.
Cause. The NO SELECT syntax with the default specification type of GENERATED
ALWAYS AS IDENTITY is not allowed.
Effect. The operation fails.
Recovery. Remove the NO SELECT syntax and resubmit the statement.
SQL 1610
Cause. You attempted to create a referential integrity constraint with the SET NULL
clause for a column, which was defined with the NOT NULL property.
Effect. The operation fails.
Recovery. Remove the SET NULL clause in the referential integrity constraint or drop
the NOT NULL constraint for the column on which you want to create the referential
integrity constraint.
SQL 1611
Cause. You attempted to create a referential integrity constraint with the SET
DEFAULT clause for a column that was defined without a DEFAULT value.
Effect. The operation fails.
Recovery. Remove the SET DEFAULT clause in the referential integrity constraint or
set a DEFAULT value for the column on which you want to create the referential
integrity constraint.
1601 Recalibration of the GENERATED ALWAYS AS IDENTITY column,
col-name, for the table, table-name, is not allowed with NO
SELECT.
1610 SET NULL clause cannot be applied to column
$0~ColumnName which has a NOT NULL constraint defined on it.
1611 SET DEFAULT clause cannot be applied to column
$0~ColumnName which has a NO DEFAULT clause.