ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-71
PROFILE Statements
CLOSE_TABLES_PER_SESSION { Y | N }
specifies whether NonStop SQL/MP tables are closed at the end of a session:
UPDATE_SYSTEM_CONFIG
resets the time to update system configuration values to the current time. This
option causes running system components to reread their configuration values on
the next polling cycle.
Considerations – ADD PROFILE
The ADD PROFILE statement:
•
Creates entries in ZNSPROF that define the configuration of the specified profile
•
Generates a warning if database-name, schema-name, trace-name,
gov-name, or control-name cannot be found in the appropriate mapping table
•
Generates an error if profile-name already exists in ZNSPROF
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
Example
ADD PROFILE myprofl SQL_DIALECT TDM_CORE SQL_UNSUPPORTED I
MODIFY PROFILE
The MODIFY PROFILE statement modifies profile attributes in the ZNSPROF table.
Y Close tables at the end of the session.
N Do not close tables at the end of the session. N is the default.