ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-10
Available NonStop SQL/MP Statements
CREATE
TABLE
Defines and creates a
table.
USERCAT
REFRESH
The table is registered in the
NonStop SQL/MP catalog but not
in the NonStop ODBC Server
mapping tables.
You cannot access the table
using the NonStop ODBC Server
unless you refresh the mapping
tables.
CREATE VIEW Creates a view. USERCAT
REFRESH
The view is registered in the
NonStop SQL/MP catalog but not
in the NonStop ODBC Server
mapping tables.
You cannot access the view
using the NonStop ODBC Server
unless you refresh the mapping
tables.
DROP Drops a catalog,
constraint, program,
table, view, or index.
Using pass-through
mode, you can drop
only catalogs that are
not customized.
REFRESH A mapping table update is
needed only if you drop a
mapped table, view, or index.
The object is dropped from the
NonStop SQL/MP catalog but is
still registered in the NonStop
ODBC Server mapping tables. If
you then try to create an object
with the name of the dropped
object, you will receive an error
message saying that the object
already exists.
Dropping a table also causes
dependent views and indexes to
be drop be dropped. If the table
is mapped, the dependent views
and indexes remain registered in
the mapping tables.
You can remove the mapping
table entry for the dropped object
and its dependent objects by
running REFRESH.
UPDATE
STATISTICS
Updates statistics
stored in the catalog for
the specified table.
None –
Table 6-1. DDL Statements Available in Pass-Through Mode (page 3 of 3)
Statement Description
Mapping
Table
Action
Needed
Mapping Table Action
Description