Availability Guide for Change Management

Making Application Subsystem Changes Online
Availability Guide for Change Management–125506
4-10
Overview of NonStop SQL/MP
•
SQLCI commands—SQLCI commands enable you to set and display the
SQLCI environment.
•
Report Writer—A full-function report-writing facility that formats custom
reports.
•
Utilities—A full set of utilities that provide quick access to information about
the database, the data dictionary, and the application programs.
•
Programmatic SQL—The NonStop SQL/MP application programming interface.
Programmatic SQL enables programmers to code SQL statements in C, COBOL85,
Pascal, and TAL host language programs.
When using NonStop SQL/MP, you access database objects. A database object is an
entity that is created, manipulated, or dropped by SQL statements. Database objects
include tables, indexes, views, constraints, and collations.
Figure 4-2 is a simplified drawing of a traditional NonStop SQL/MP database system.
Figure 4-2. A Traditional NonStop SQL/MP Database System
Data
Dictionary
Business
Data
Data
Dictionary
Business
Data
Programmatic
SQL
OLTP
Applications
Business
Professional
Database
Administrator
Application
Programmer
Application
User
NonStop SQL/MP
Database
SQLCI
Tandem NonStop System
Utilities
Report Writer
Commands
SQL
Statements