ODBC Server Reference Manual

CORE SQL Language

HP NonStop ODBC Server Reference Manual—429151-002

3-50

Dropping Dependent Views and Indexes

You should drop dependent views and indexes before dropping a view using the

NonStop ODBC Server.

When you drop a view using the NonStop ODBC Server, NonStop SQL/MP drops the

view and all dependent views and indexes. The NonStop ODBC Server, however, does

not clear the mapping table entries for the views or indexes.

The only way to clear the mapping table entries in this situation is to run the catalog

utility statement REFRESH.

For information about REFRESH, see Section 7, Managing Customized Catalogs.

CORE SQL Compared With NonStop SQL/MP

The corresponding NonStop SQL/MP statement is DROP VIEW, which functions the

same as the CORE SQL statement, although it does not contain the CASCADE

clause.

GRANT

The NonStop ODBC Server recognizes the syntax of the GRANT statement, but does

not perform its activities.

The GRANT statement has the following syntax:

The setting of the SQL_UNSUPPORTED flag in the ZNSPROF mapping table

determines whether the NonStop ODBC Server reports an error, issues a warning

message, or ignores the GRANT statement.

Note. When the mapping table entries are not cleared and you later attempt to create a view

or index by the same name, you will receive error messages saying that the object already

exists when in fact it does not.

GRANT { ALL }

{ grant-privilege [‚ grant-privilege ] ... }

ON table-name

TO { PUBLIC }

{ user-name [‚ user-name ] ... }