SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
3-79
Cause. When Similarity Check is enabled for views, creating or altering a view
containing nested views or a VALUES constructor is not supported. For more
information, see the SQL/MX 3.2 Reference Manual.
When a view definition contains nested views or a VALUES constructor or both, this
error is returned for the following conditions:

CREATE or ALTER VIEW statement syntax with Similarity Check enabled

CREATE VIEW statement syntax does not specify the Similarity Check option and
the CQD DDL_VIEW_SIMILARITY_CHECK is set to ON.
Effect. The operation fails.
Recovery. Modify the syntax by removing references to the nested views or VALUES
constructor and resubmit the statement.
SQL 1617
Where string is enabled or disabled.
Cause. You issued an ALTER VIEW statement for one of the following conditions:

Enable Similarity Check on a view for which Similarity Check is already enabled.

Disable Similarity Check on a view for which Similarity Check is already disabled.
Effect. The operation fails.
Recovery. Use SHOWDDL to verify if Similarity Check is enabled or disabled for a
view before submitting an ALTER VIEW statement again.
SQL 1620
Cause. You specified a non-zero value for scale in the CREATE SEQUENCE
statement.
Effect. The statement fails to execute.
Recovery. Resubmit the statement with scale set to zero.
SQL 1621
Where seq-max is 28.
1617 Similarity Check is already string.
1620 Scale should be zero for sequence generator.
1621 Maximum allowed precision for a sequence generator is
seq-max.