ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-121
Catalog Support Procedures
\node.subvolume.filename
\node.$volume.subvolume.filename
The NonStop ODBC Server fully qualifies nssql-filename before performing the
REMOVE VIEW statement. Any optional values you omit are determined by the
user profile of the current process.
Considerations – REMOVE VIEW
The REMOVE VIEW statement:
•
Removes a mapping entry in ZNUOBJ for the specified view
•
Preserves the underlying NonStop SQL/MP object
•
Generates a warning if nssql-filename is referenced by a profile entry in
ZNSPROF
Example
REMOVE VIEW \sales.$db1.region2.vw
Catalog Support Procedures
ODBC provides several procedures for ODBC catalog support. These procedures are
functions the ODBC driver supports, and are useful to users who build programs using
the ODBC driver.
You invoke each procedure with a Microsoft Windows call. The driver issues the
queries, which return information from the ODBC catalog by populating a list of
columns. Some columns are in result sets, and others are in named
program-generated views. The output is dynamic and is composed of elements of
NonStop SQL for which there is no equivalent API functionality.
These are the procedures:
•
SQLColumns
•
SQLPrimaryKeys
•
SQLProcedureColumns
•
SQLProcedures
•
SQLSpecialColumns
•
SQLStatistics
•
SQLTables
The following subsections provide information about these procedures. The view
names are included for those procedures that generate views.
For more information about these procedures, see the Microsoft ODBC 2.0
Programmer’s Reference and SDK Guide.