SQL/MP Installation and Management Guide

The SQL/MP Database Management Environment
HP NonStop SQL/MP Installation and Management Guide—523353-004
1-12
Database Management Tools
CONVERT Converts an Enscribe file definition to an
equivalent SQL CREATE TABLE statement and,
optionally, generates SQLCI LOAD commands for
loading data from the Enscribe file into an
equivalent SQL table.
COPY Copies data to and from Enscribe files and SQL
tables, adding to existing data.
DISPLAY USE OF Displays a list of SQL objects that depend on
specified objects.
DUP Makes identical copies of Guardian files or of
objects and object descriptions.
EXPLAIN Explains how data is accessed by specific DML
statements and displays DEFINE mappings.
FILEINFO Displays physical characteristics of objects and
files.
FILENAMES Displays a set of names that match a pattern
specified with wild-card characters.
FILES Displays the names of files that are on one or
more subvolumes.
INVOKE Generates a record description of a table or view.
LOAD Loads data into a file or table, overwriting existing
data.
MODIFY
[DICTIONARY]
Modifies node numbers stored in file labels of SQL
objects (LABEL option), modifies node names
stored in SQL catalogs on the local node
(CATALOG option), and registers user-defined
catalogs in the local system catalog (REGISTER
option).
PURGE Purges one or more objects or Guardian files.
PURGEDATA Deletes data from Guardian files and tables.
SECURE Changes the owner or security of one or more
objects or Guardian files.
UPGRADE
CATALOG
Upgrades catalogs created with an older version
of SQL/MP to the format required to use new
features in a newer version.
VERIFY Checks the consistency and validity of object
definitions in catalogs and file labels and displays
names of invalid programs.
Table 1-1. SQL/MP Statements and Commands for Database
Management (page2of3)
Statement or
Command Type
Statement or
Command Description