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

SyntaxDescriptionCommand
See the“SET MARKUP Command”
(page 114).
Sets the markup format and controls
how results are displayed by NCI.
SET MARKUP
See the “SET PARAM Command”
(page 117).
Sets a parameter value in the current
session.
SET PARAM
See the “SET PROMPT Command”
(page 118).
Sets the prompt of the current session
to a specified string or to a session
variable.
SET PROMPT
See the “SET SQLPROMPT
Command” (page 120).
Sets the SQL prompt of the current
session to a specified string. The default
is SQL.
SET SQLPROMPT
See the “SET SQLTERMINATOR
Command” (page 122).
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 122).
Automatically retrieves the statistics
information for a query being executed.
SET STATISTICS
See the “SET TIME Command”
(page 123).
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 124).
Causes the elapsed time to be displayed
after each SQL statement executes.
SET TIMING
See the“SHOW ACCESS Command”
(page 125).
Displays the current status of the
SUPER.SERVICES access to memory
dump files.
SHOW ACCESS
See the “SHOW ACTIVITYCOUNT
Command” (page 125).
Functions as an alias of “SHOW
RECCOUNT Command” (page 136).
SHOW ACTIVITYCOUNT
See the “SHOW ALIAS Command”
(page 125).
Displays all or a set of aliases available
in the current NCI session.
SHOW ALIAS
See the “SHOW ALIASES Command”
(page 126).
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 127).
Functions as an alias for the “SHOW
LASTERROR Command” (page 129).
SHOW ERRORCODE
See the “SHOW FETCHSIZE
Command” (page 128).
Displays the fetch size value for the
current NCI session.
SHOW FETCHSIZE
See the “SHOW HISTOPT Command”
(page 128).
Displays the value that has been set for
the history option of the current setting.
SHOW HISTOPT
See the “SHOW IDLETIMEOUT
Command” (page 129).
Displays the idle timeout value of the
current session.
SHOW IDLETIMEOUT
See the “SHOW LASTERROR
Command” (page 129).
Displays the last error of the statement
that was executed.
SHOW LASTERROR
See the “SHOW LIST_COUNT
Command” (page 130).
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 130).
Displays the value that has been set for
the markup option for the current NCI
session.
SHOW MARKUP
See the “SHOW MODE Command”
(page 131).
Displays the operating mode of the
current session.
SHOW MODE
See the “SHOW MVGROUPS
Command” (page 131).
Displays all or a set of the materialized
view groups in the current schema of
the NCI session.
SHOW MVGROUPS
73