ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-8
Available NonStop SQL/MP Statements
Available NonStop SQL/MP Statements
A subset of NonStop SQL/MP statements is available in pass-through mode. Table 6-1
through Table 6-4 summarize the NonStop SQL/MP DDL, DCL, DML, and Dynamic
SQL statements that you can use.
After executing some statements, you might need to update the NonStop ODBC
Server mapping tables to make an object available through the NonStop ODBC Server.
For details, see Updating the Mapping Tables on page 6-12.
Table 6-1. DDL Statements Available in Pass-Through Mode (page 1 of 3)
Statement Description
Mapping
Table
Action
Needed
Mapping Table Action
Description
ALTER
CATALOG
Alters security attributes
for catalogs.
None –
ALTER INDEX Adds or drops index
partitions or alters
attributes of indexes
such as the index
name, security
attributes, or file
attributes.
USERCAT
REFRESH
A mapping table update is
needed only if you rename a
mapped index and will need to
drop the index using the NonStop
ODBC Server.
ALTER
PROGRAM
Alters security attributes
for a program or
renames a program.
None –
ALTER TABLE Adds new columns to a
table, adds and drops
table partitions, alters
table properties such as
security attributes or file
attributes, or renames a
table.
If you change the owner
of a mapped table, the
new owner name is not
reflected in the NonStop
ODBC Server mapping
tables. You must use
the original owner name
when accessing the
table using the NonStop
ODBC Server.
USERCAT
REFRESH
A mapping table update is
needed only if you rename a
mapped table.
The file name of the table is
changed, but the file name listed
in the NonStop ODBC Server
mapping tables is not. You
cannot access the table using the
NonStop ODBC Server unless
you refresh the mapping tables.
If you rename a mapped table
and then update the mapping
tables, the ODBC/SQL Server
name of the table changes
(unless you are changing the
name of a table generated by
NonStop ODBC Server).