ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-39
Developing Custom Applications
for the catalog tables are enforced only by the NonStop ODBC Server products
(NonStop ODBC Server and NOSUTIL), and end-users are not aware of these rules. It
is also possible that the integrity rules or the NonStop ODBC Server catalog structure
might change with future releases, which would could cause end-user applications to
fail or to corrupt the NonStop ODBC Server catalog tables.
It is possible for you to use tools or develop applications to display information in the
NonStop ODBC Server catalog tables. There are two considerations in this area:
•
The tool or application should not update the NonStop ODBC Server catalog tables
directly, as integrity rules in the catalog must be maintained. Instead, it should use
pass-through statements to invoke NOSUTIL to make the necessary changes.
•
The schema and semantics of the NonStop ODBC Server catalog should be
expected to change in the future to meet new requirements. Consequently, the tool
or application must be prepared to evolve as necessary. The NonStop ODBC
Server supports making versions of the catalogs so you can discern when changes
occur. The NonStop ODBC Server system catalog table ZNSDB, which contains an
entry for each catalog on the system, records the version of the catalog in the
T_VERSION column. For the D43 release, the catalog version number is 200.