Availability Guide for Change Management

Tools for Online Change

Availability Guide for Change Management–125506

7-13

Considerations and Limitations of SQLCI

Section 4, “Making Application Subsystem Changes Online,” describes the changes you

can make to NonStop SQL/MP online, including which types of changes can affect

system and application availability.

SQLCI Example

The following example shows how you would add a catalog to an existing data

dictionary using SQLCI. (A data dictionary is the collection of all catalogs and

associated file labels that describe all the NonStop SQL/MP objects and programs that

make up the database.)

Use the CREATE CATALOG statement to add a catalog. The following command

creates a catalog named PERSNL on the \SYS1 system and $VOL1 volume:

>> CREATE CATALOG \SYS1.$VOL1.PERSNL;

Where to Find More Information

The NonStop SQL/MP Reference Manual describes SQLCI and the syntax of SQL

statement.

Figure 7-3. How SQLCI Works

CDT 012

SQLCI

Command

Terminal

Database

SQL

Statements

Commands

Utilities

Report Writer

Host

Language

Program