Neoview Command Interface (NCI) Guide (R2.4)

SyntaxDescriptionCommand
See the “SET PROMPT Command”
(page 127).
Sets the prompt of the current session
to a specified string or to a session
variable.
SET PROMPT
See the “SET SQLPROMPT
Command” (page 129).
Sets the SQL prompt of the current
session to a specified string. The default
is SQL.
SET SQLPROMPT
See the “SET SQLTERMINATOR
Command” (page 130).
Sets the SQL statement terminator of
the current session to a specified string.
The default is a semicolon (;).
SET SQLTERMINATOR
See the “SET STATISTICS Command”
(page 131).
Automatically retrieves the statistics
information for a query being executed.
SET STATISTICS
See the “SET TIME Command”
(page 131).
Causes the local time of the client
workstation to be displayed as part of
the interface prompt.
SET TIME
See the“SET TIMING Command”
(page 132).
Causes the elapsed time to be displayed
after each SQL statement executes.
SET TIMING
See the“SHOW ACCESS Command”
(page 133).
Displays the current status of the
super.services access to memory dump
files.
SHOW ACCESS
See the “SHOW ACTIVITYCOUNT
Command” (page 133).
Functions as an alias of “SHOW
RECCOUNT Command” (page 144).
SHOW ACTIVITYCOUNT
See the “SHOW ALIAS Command”
(page 133).
Displays all or a set of aliases available
in the current NCI session.
SHOW ALIAS
See the “SHOW ALIASES Command”
(page 134).
Displays all the aliases available in the
current NCI session.
SHOW ALIASES
See the “SHOW COLSEP Command”.Displays the value of the column
separator for the current NCI session.
SHOW COLSEP
See the “SHOW ERRORCODE
Command” (page 135).
Functions as an alias for the “SHOW
LASTERROR Command” (page 137).
SHOW ERRORCODE
See the “SHOW FETCHSIZE
Command” (page 136).
Displays the fetch size value for the
current NCI session.
SHOW FETCHSIZE
See the “SHOW HISTOPT Command”
(page 136).
Displays the value that has been set for
the history option of the current setting.
SHOW HISTOPT
See the “SHOW IDLETIMEOUT
Command” (page 137).
Displays the idle timeout value of the
current session.
SHOW IDLETIMEOUT
See the “SHOW LASTERROR
Command” (page 137).
Displays the last error of the statement
that was executed.
SHOW LASTERROR
See the “SHOW LIST_COUNT
Command” (page 138).
Displays the maximum number of rows
to be returned by SELECT statements
in the current session.
SHOW LIST_COUNT
See the “SHOW MARKUP
Command” (page 138).
Displays the value that has been set for
the markup option for the current NCI
session.
SHOW MARKUP
See the “SHOW MODE Command”
(page 139).
Displays the operating mode of the
current session.
SHOW MODE
See the “SHOW MVGROUPS
Command” (page 139).
Displays all or a set of the materialized
view groups in the current schema of
the NCI session.
SHOW MVGROUPS
See the “SHOW MVS Command”
(page 140).
Displays all or a set of the materialized
views in the current schema of the NCI
session.
SHOW MVS
See the “SHOW PARAM Command”
(page 141).
Displays the parameters that are set in
the current session.
SHOW PARAM
87