ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-60
NonStop ODBC Server Compared With SQL Server
Shorthand Views and Protection Views
NonStop SQL/MP has two types of views:
When you create a view using the NonStop ODBC Server, it attempts to create a
protection view. If the create fails, however, the NonStop ODBC Server creates a
shorthand view. No messages are generated indicating the type of view created.
You will know that the NonStop ODBC Server created a shorthand view if you get an
error message when you try to insert or update data in the view.
The view definition text indicates whether a view is a shorthand or a protection view.
You can list this text by querying the NonStop SQL/MP VIEWS table, which resides on
the subvolume of your NonStop SQL/MP catalog. The following SQLCI statement lists
the view definition text for a view:
select viewtext from views where viewname =
"\TEST.$VOL2.PERSNL.EMPLIST";
Is the view definition
text visible?
Yes, in the
SYSCOMMENTS
system table.
Yes, but not in the SYSCOMMENTS
catalog.
The text is visible in the NonStop SQL/MP
VIEWS catalog table if the user can
determine the NonStop SQL/MP name
used for the view.
See Locating Objects Using the Mapping
Tables on page 7-4.
Is auditing of the
volume necessary?
N.A. Yes, the volume on which the view is
created must be audited by TMF.
Should view names be
unique?
Yes, for a specific
database and
owner.
Yes, the fully expanded name must be
unique in the network.
Can you name another
user as the owner of the
new view?
No Yes, if the specified owner name is a valid
Guardian logon name.
Shorthand Derived from one or more tables or other views and defined without the
protection attribute.
A shorthand view can be read but not updated.
Protection Derived from a single table by taking a projection of the columns of the
table, or a selection of the rows of the table, or both. For more
information about the rules for protection views, see CREATE VIEW in
the NonStop SQL/MP Reference Manual.
A protection view can be secured, updated, and read.
Feature In SQL Server
In Programs Used With the NonStop
ODBC Server