ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-3
Summary of Tasks
Table 7-1. Tasks That Involve Customization and Catalog Utilities (page 1 of 2)
Task What You Need to Do
Where to Find Further
Information
Access a NonStop
SQL/MP catalog using
the NonStop ODBC
Server
First, customize the catalog. SYSCAT INSTALL Statement
on page 7-18 and USERCAT
INSTALL Statement on
page 7-20
Create a database
using the NonStop
ODBC Server
Log on to the NonStop ODBC
Server and execute the
Transact-SQL statement CREATE
DATABASE.
You do not need to perform any
additional steps to customize the
catalog, because when you
execute CREATE DATABASE, the
NonStop ODBC Server creates a
NonStop SQL/MP catalog and all
the necessary mapping tables, and
completes the customizing
automatically.
CORE SQL has no CREATE
DATABASE statement; instead,
(See Section 4,
Transact-SQL Language, for
information on creating
databases)
USERCAT INSTALL
Statement on page 7-20
Use pass-through
mode to create a
NonStop SQL/MP
object in a customized
catalog
When you create the object, it is
not visible through the NonStop
ODBC Server. To make the object
visible, update the mapping tables
after you create the object.
SYSCAT REFRESH
Statement on page 7-27 and
USERCAT REFRESH
Statement on page 7-29 or
ADD TABLE on page 7-105,
ADD INDEX on page 7-50, or
ADD VIEW
on page 7-119
Use NonStop SQL/MP
to create an object in
a customized catalog
When you add the object, it is not
visible through the NonStop ODBC
Server, so you must first refresh or
update the mapping tables.
SYSCAT REFRESH
Statement on page 7-27 and
USERCAT REFRESH
Statement on page 7-29 or
ADD TABLE on page 7-105,
ADD INDEX on page 7-50, or
ADD VIEW
on page 7-119
Access an object
using NonStop
SQL/MP when the
object was created
using the NonStop
ODBC Server
Determine the NonStop SQL/MP
file name of the object by looking
in the mapping tables.
Locating Objects Using the
Mapping Tables on page 7-4