SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
3-77
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 1602
Cause. The user specified value for resetting the CURRENT_VALUE is lesser than
the MINVALUE of the sequence generator.
Effect. The statement fails to execute.
Recovery. Increase the RESTART WITH value to a number greater than or equal to
MINVALUE.
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.
1601 Recalibration of the GENERATED ALWAYS AS IDENTITY column,
col-name, for the table, table-name, is not allowed with NO
SELECT.
1602 The RESTART WITH value should be equal to or greater than
the MINVALUE of the sequence generator.
1610 SET NULL clause cannot be applied to column
$0~ColumnName which has a NOT NULL constraint defined on it.