ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-9
Available NonStop SQL/MP Statements
ALTER VIEW Alters security attributes
for a view or renames a
view.
If you change the owner
of a mapped view, the
new owner name is not
reflected in the NonStop
ODBC Server mapping
tables.
USERCAT
REFRESH
A mapping table update is
needed only if you rename a
mapped view.
The file name of the view is
changed, but the file name listed
in the NonStop ODBC Server
mapping tables is not changed.
You cannot access the view
using the NonStop ODBC Server
unless you refresh the mapping
tables.
If you rename a mapped view
and then update the mapping
tables, the ODBC/SQL Server
name of the view could change.
CREATE
CATALOG
Creates a NonStop
SQL/MP catalog.
USERCAT
INSTALL
NonStop SQL/MP creates a
catalog on the specified
subvolume. NonStop ODBC
Server mapping tables are not
created, however.
You cannot access the catalog
using the NonStop ODBC Server
unless you customize the
catalog.
CREATE
CONSTRAINT
Defines an integrity
constraint for a table.
When a constraint is in
effect, all rows inserted
or updated must satisfy
the constraint.
None –
CREATE
INDEX
Creates an index on a
base table.
USERCAT
REFRESH
The index is registered in the
NonStop SQL/MP catalog but not
in the NonStop ODBC Server
mapping tables. (This is an issue
only if you want to drop the index
later, or if you want an accurate
list of user objects seen through
the NonStop ODBC Server).
Table 6-1. DDL Statements Available in Pass-Through Mode (page 2 of 3)
Statement Description
Mapping
Table
Action
Needed
Mapping Table Action
Description