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

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-50
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-40.
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;