ODBC Server Reference Manual

Using Pass-Through Mode
HP NonStop ODBC Server Reference Manual—429151-002
6-12
Updating the Mapping Tables
For details on the NonStop SQL/MP statements, see the NonStop SQL/MP Reference
Manual.
Updating the Mapping Tables
When you use pass-through mode to execute NonStop SQL/MP statements on
customized catalogs, the changes made are not always reflected in the NonStop
ODBC Server mapping tables. Therefore, you might need to update the mapping
tables if you want the changes visible through the NonStop ODBC Server.
Deciding Whether to Update the Mapping Tables
The following situations indicate when you would need to update the mapping tables
after using pass-through mode:
INSERT Inserts rows into a table
or protection view.
None –
SELECT Retrieves data from
tables and views.
None –
UPDATE Updates values in
columns of a table or
protection view.
None –
Table 6-4. Dynamic SQL Statements Available in Pass-Through Mode
Statement Description
Mapping
Table
Action
Needed
Mapping Table Action
Description
EXECUTE Executes a previously
compiled statement.
Depends If you execute a DDL
statement, you might need to
update the mapping tables.
See Ta ble 6-1
for information
on DDL statements.
PREPARE Compiles a DDL, DML,
or DCL statement.
None –
RELEASE Deallocates memory for
a prepared SQL
statement.
None –
Table 6-3. DML Statements Available in Pass-Through Mode (page 2 of 2)
Statement Description
Mapping
Table
Action
Needed
Mapping Table Action
Description