SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-64
SQLCI Commands
WRITER. SQL statements—most of which you can use in SQLCI—are summarized
separately in the entry STATEMENTS.)
Table S-2. Summary of SQLCI Commands (page1of4)
Command Action
CANCEL Command
Cancels the current SELECT
CATALOG Command
Selects a different default catalog
CLEANUP Command
Purges damaged SQL objects
CONVERT Command
Generates commands to convert Enscribe files to SQL tables
COPY Command
Copies data into an Enscribe file or SQL table, adding to existing
data
CREATE SYSTEM
CATALOG Command
Creates the system catalog when NonStop SQL/MP is first installed
DELETE DEFINE
Command
Deletes DEFINEs
DISPLAY
STATISTICS
Command
Displays statistics for a recently compiled DML statement
DISPLAY USE OF
Command
Displays a list of SQL objects that depend on a specified object
DOWNGRADE
CATALOG Command
Downgrades catalogs to an older version
DOWNGRADE
SYSTEM CATALOG
Command
Downgrades the system catalog to an older version
DROP SYSTEM
CATALOG Command
Deletes the system catalog
DUP Command
Duplicates files or objects
EDIT Command
Invokes the EDIT text editor
ENV Command
Displays attributes of the current SQLCI session
ERROR Command
Displays error text
EXIT Command
Ends an SQLCI session
FC Command
Edits and reexecutes a previously entered command
FILEINFO Command
Lists physical characteristics of collations, files, indexes, programs,
tables, and views
FILENAMES
Command
Displays names of files and tables that match a specified pattern
FILES Command
Displays names of files and tables on a subvolume
FUP Command
Invokes the File Utility Program
HELP Command
Displays information about NonStop SQL/MP