ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-120
VIEW Statements
Considerations – ADD VIEW
The ADD VIEW statement:
•
Creates a new mapping entry in ZNUOBJ for the specified view
•
Adds a mapping entry to ZNSUS if logical-username is not currently mapped
to the owner of nssql-filename
•
Generates an error if you do not have read access to nssql-filename, or if you
do not have write access to the mapping tables associated with
logical-objectname
•
Generates an error if nssql-filename is already mapped in the appropriate
object file.
•
Generates an error if nssql-filename is not a valid NonStop SQL/MP view
•
Generates an error if the view you specify is not registered in the NonStop SQL/MP
database
•
Generates an error if you are not a privileged user
•
Generates an error if database-name is not the name of a customized NonStop
ODBC Server database
•
Generates an error if logical-objectname is already mapped to a different
Guardian file name
If an ADD VIEW operation fails for any reason, the mapping tables are unchanged
Example
ADD VIEW \sales.$db1.region2.vw AS vw2
REMOVE VIEW
The REMOVE VIEW statement deletes an existing mapping entry for the specified
NonStop SQL/MP view. The underlying view is unaffected. To execute REMOVE
VIEW, you must be a privileged user.
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
REMOVE VIEW nssql-filename