SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-65
SQLCI Commands
HISTORY Command Displays recently executed commands
INFO DEFINE
Command
Displays attributes and values associated with DEFINEs
INITIALIZE SQL
Command
Prepares a node to run SQL
INVOKE Directive
and Command
Generates a record description of a table or view
LIST Command
Displays rows returned by a SELECT
LOAD Command
Loads data into an Enscribe file or SQL table, overwriting existing
data
LOG Command
Starts or ends session logging
MODIFY CATALOG
Modifies node names in SQL catalogs on the local node
MODIFY LABEL
Modifies node numbers in file labels on the local node
MODIFY REGISTER
Command
Registers a user-defined catalog in the local system catalog
OBEY Command
Executes commands from a file
OUT Command
Specifies or closes the output file
PAGE FOOTING
Command
Specifies text for the bottom of each page
PAGE TITLE
Command
Specifies text for page title
PERUSE Command
Invokes the PERUSE utility program
PURGE Command
Purges objects or files
PURGEDATA
Command
Erases data from files or tables
REPORT FOOTING
Command
Specifies text for the end of a report
REPORT TITLE
Command
Specifies text for the main title of a report
RESET DEFINE
Command
Clears DEFINE values
RESET LAYOUT
Command
Resets layout options
RESET PARAM
Command
Clears parameter values
RESET PREPARED
Command
Resets prepared commands
Table S-2. Summary of SQLCI Commands (page2of4)
Command Action