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

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
6-56
Cause. The referential integrity constraint or unique constraint of the table is
inaccessible because it is deleted.
Effect. The operation fails.
Recovery. Retry the operation. If the error persists, contact your service provider.
SQL 4362
Cause. ASC/DESC was specified in the expression of the RANK sequence function.
Effect. The statement fails to prepare.
Recovery. Rewrite the query so that it does not contain ASC/DESC in the argument of
the RANK sequence function.
SQL 4386
Where affected-table is the table, which is updated.
Where referencing-table is the table that references the affected-table
through an incompatible RI constraint.
Cause. Update of a primary key column is not supported when that column is
referenced by an RI constraint that uses the CASCADE, SET DEFAULT, or SET NULL
referential action in combination with the ON UPDATE or ON DELETE rule.
Effect. The statement does not compile.
Recovery. None. Use the SHOWDDL command to see the RI constraints which
reference the affected-table.
4362 Using ASC/DESC with sequence functions is not supported.
4386 Update on primary key using blocking operator is not
supported. Table affected-table is referenced by an
incompatible RI constraint on table referencing-table.