SQL/MP Installation and Management Guide

The SQL/MP Database Management Environment
HP NonStop SQL/MP Installation and Management Guide—523353-004
1-11
Database Management Tools
•
Data Status Language (DSL) statements that retrieve status information about
catalogs and about versions of objects and software components.
In addition, SQL/MP supplies installation commands to install SQL/MP and a set of
database management utilities.
DDL, DML, DCL, and DSL statements, Guardian utilities, and SQL utilities are the
basic tools of the SQL/MP database administrator. All these statements and
commands are available through the SQL/MP conversational interface (SQLCI).
Table 1-1 summarizes SQL/MP statements and commands for database management.
Note. For SQL programs in the OSS environment, OSS utilities are available that support DDL
functions. SQLCI and the SQL utilities listed in Table 1-1 do not, in general, support SQL
programs stored in OSS files, although exceptions are noted in descriptions of individual SQL
utilities in this manual. For more information about OSS utilities, see the Open System
Services Shell and Utilities Reference Manual.
Table 1-1. SQL/MP Statements and Commands for Database
Management (page1of3)
Statement or
Command Type
Statement or
Command Description
DDL ALTER Alters the definition of a table; changes the
attributes of an index or table; alters security
attributes of a catalog, index, program, table, or
view; renames an index, table, view, or SQL
program stored in a Guardian file; adds, moves, or
drops a partition of a table or index; splits a
partition of a table or index.
COMMENT Adds a comment to an object definition.
CREATE Creates a catalog, constraint, index, table, or view.
DROP Drops a catalog, constraint, index, table, view, or
SQL program stored in a Guardian file.
HELP TEXT Specifies help text for a column of a table or view.
UPDATE
STATISTICS
Updates information about the contents of a table
and its indexes.
Operation on
Other SQL
Statements
DISPLAY
STATISTICS
Displays information about the most recently
executed DML or PREPARE statement.
Utilities APPEND Appends data to the end of a table or table
partition, adding to existing data.
CLEANUP Deletes damaged SQL objects that result from
corruption of definitions in the data dictionary.