ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-5
Table Mapping Security
By taking advantage of the changeable default values, you receive the following
benefits:
•
The flexibility to change attributes without requiring changes to program code
•
Visibility of the results
•
More control over the system
You change the default values throughout the system by using the ADD, MODIFY, or
REMOVE statement on the ZNSSCFG table. For information on changing default
values for the duration of a process, see “During Session Initialization.”
When a Process Begins
When the NOSUTIL, NOS, and SCS processes start up, they each initialize their
program default values to the values in the ZNSSCFG table. These values are in effect
for a time specified in the ZNSSCFG table. The value is stored in the VALUE column of
the row whose ITEM is “CHECK_INTERVAL_SECS”.
For more information on the CHECK_INTERVAL_SECS column, see ZNSSCFG (For
System Configuration Values) on page 8-28. For a list of ZNSSCFG default values, see
Appendix D, Summary of System Installation Defaults.
During Session Initialization
A user can change some defaults during a session by using the SET statement. The
changed values override the values on the ZNSSCFG table and are in effect for the
duration of the session. At the end of the session, they revert to the values on the
ZNSSCFG table. For information on the SET statement, see the subsection SET on
page 4-92.
The system configuration default values are initialized during each session initialization
(by NOS) when a change has been recorded since the last time a process read the
value. The LAST_UPDATE_SYSTEM_CONFIG column in the ZNSSCFG table stores
the date and time of the change.
Table Mapping Security
The mapping tables in the system catalog are created when the NonStop ODBC
Server is installed. The tables are created with the security “NNNO” or “NONO,”
depending on whether a given table is modified during normal operations. For
example, ZNSDB is assigned security “NNNO” so users can create or drop databases,
adding or deleting entries in ZNSDB (SYSDATABASES); ZNUDT is different. ZNUDT is
assigned security “NONO,” as its values are static for a given release of the NonStop
ODBC Server.
The mapping tables for user catalogs are created when an existing catalog is
customized or when a database is created using the NonStop ODBC Server.
See also Renaming ODBC or SQL Server Objects on page 7-7.