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

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-43
Considerations for ALTER VIEW
similarity-check-option
ENABLE SIMILARITY CHECK
enables Similarity Check for the view.
DISABLE SIMILARITY CHECK
disables Similarity Check for the view.
Considerations for ALTER VIEW
Authorization and Availability Requirements
To alter a view, you must own its schema or be the super ID or object owner.
Renaming a View
You can use the rename option to change the name of a view. The following are the
prerequisites for renaming a view:

The view and its file label must be available.

The new ANSI name must not already exist within the schema.
Similarity Check

For the Similarity Check setting to become effective after issuing an ALTER VIEW
statement, you must recompile the applications using the view.

An error is returned if an attempt is made to ENABLE SIMILARITY CHECK on a
view for which Similarity Check is already enabled or DISABLE SIMILARITY
CHECK on a view for which Similarity Check is already disabled.
Effects on TMF
Rename
For information on effects of the rename option on TMF, see Effects on TMF
on
page 2-33.
Example of ALTER VIEW

The following command renames the view, CAT.SCH.V1 to V2:
ALTER VIEW CAT.SCH.V1 RENAME TO V2;
The new view, V2 continues to remain in the same catalog and schema as V1.

The following command enables Similarity Check on the view:
ALTER VIEW CAT.SCH.V1 ENABLE SIMILARITY CHECK;