Availability Guide for Change Management

Tools for Online Change
Availability Guide for Change Management–125506
7-12
Where to Find More Information
Where to Find More Information
The PATHCOM interface is described in the NonStop TS/MP and Pathway Management
Reference Manual. The NonStop TS/MP and Pathway Management Programming
Commands Manual describes the token-oriented management programming interface to
NonStop TS/MP and Pathway/TS.
NonStop SQL/MP Management Tools
NonStop SQL/MP is a relational-database-management system that supports high-speed
access and updates to distributed data. NonStop SQL/MP uses SQL to create relational
databases and to describe and manipulate data. NonStop SQL/MP is one of the core
services that make up the Tandem application environment.
NonStop SQL/MP Management Interfaces
Tandem provides two ways to make changes to NonStop SQL/MP:
•
Interactively using the NonStop SQL/MP conversational interface (SQLCI)
•
Programmatically, by embedding SQL statements in host language programs
These interfaces are provided with the NonStop SQL/MP product.
SQLCI
SQLCI is the primary interface through which database administrators create and change
structures to manage data. SQLCI provides SQL DDL statements to define the
database, SQL data manipulation language (DML) statements to query and modify
database tables, installation commands to install NonStop SQL, a set of database
management utilities, and a report-writer facility.
SQL statements operate on database objects. A database object is an entity that is
created, manipulated, and dropped by SQL statements. Examples of SQL objects
include tables, indexes, views, constraints, and collations.
Programmatic SQL
The application programming interface to NonStop SQL/MP enables you to use SQL
statements in C, COBOL85, Pascal, pTAL, and TAL host language programs to access
NonStop SQL/MP databases and to control database processing.
How SQLCI Works
Figure 7-3 shows how the various components of SQLCI relate to a NonStop SQL/MP
database.