SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Understanding and Planning SQL/MX Tables
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
4-11
Using Views

To present only the columns and rows a user needs to work with instead of all the
columns and rows in underlying tables or views.
ANSI Views
SQL/MX views conform to the SQL:1999 standard and have these attributes:

You can change the data in the underlying table through a view if the view is
updatable. A view that references more than one table is not updatable.

A view can be secured separately from the underlying tables or views. Users of the
view do not need to have access privileges to these underlying objects to access
the view.
Note. A view does not insulate the programs that use it from being invalidated by changes to
the table definition. Even changes that do not directly affect the view require that the programs
be explicitly SQL compiled to be revalidated. The requirement for explicit compilation is the
same as if the programs used the table directly.