ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-119
VIEW Statements
VIEW Statements
Use the following statements to control whether a NOSCOM user can access a
specified view of a NonStop SQL/MP base table:
•
ADD VIEW
•
REMOVE VIEW
ADD VIEW
The ADD VIEW statement makes the specified view of a NonStop SQL/MP base table
visible to a NOSCOM user. No REFRESH of the entire database is necessary.
To execute ADD VIEW, you must be a privileged user. However, the NonStop ODBC
Server does not verify privileges on the underlying NonStop SQL/MP view.
nssql-filename
is an alphabetic string up to 34 characters in length that identifies a Guardian file
that represents the physical location of the view; nssql-filename can be in any
of the following formats:
filename
subvolume.filename
$volume.subvolume.filename
\node.filename
\node.subvolume.filename
\node.$volume.subvolume.filename
The NonStop ODBC Server fully qualifies nssql-filename before performing the
VIEW operation. Any optional values you omit are determined by the user profile of
the current process.
AS logical-objectname
is an alphanumeric string up to 182 characters in length that specifies the logical
name of the view; logical-objectname can be in any of the following formats:
object-name
logical-user-name.object-name
database-name.logical-user-name.object-name
database-name..object-name
Any value you specify for database-name must be a customized NonStop ODBC
Server database.
The NonStop ODBC Server fully qualifies logical-objectname before
performing the VIEW operation. Any optional values you omit are determined by
the user profile of the current process.
ADD VIEW nssql-filename [ AS logical-objectname ]