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

Syntax
SAVEHIST file-name [CLEAR]
file-name
is the name of a file into which NCI stores the session history. If you want the history file to
exist outside the local directory where you launch NCI (by default, the Neoview Command
Interface bin directory), specify the full directory path of the history file. The specified
directory must exist before you execute the SAVEHIST command.
CLEAR
instructs NCI to clear the contents of the specified file before adding the session history to
the file.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• If the specified file already exists, NCI appends newer session-history information to the
file.
Examples
• This command clears the contents of an existing file named history.txt in the local directory
(the same directory where you are running NCI) and saves the session history in the file:
SQL>savehist history.txt clear
SQL>
• This command saves the session history in a file named hist.txt in the specified directory on
a Windows workstation:
SQL>savehist c:\log_files\hist.txt
SQL>
• This command saves the session history in a file named hist.txt in the specified directory on
a Linux or UNIX workstation:
CS#savehist ./log_files/hist.txt
CS#
For more information, see “Displaying Executed Commands” (page 66).
SET COLSEP Command
The SET COLSEP command sets the column separator and allows you to control the formatting
of the result displayed for SQL queries. The SET COLSEP command specifies a delimiter value
to use for separating columns in each row of the results. The default delimiter is “ ”(white
space).
Syntax
SET COLSEP [separator]
Considerations
You must enter the command on one line. The SET COLSEP command can be executed only in
SQL mode.
The SET COLSEP command has no effect if the markup is set to HTML, XML, or CSV.
118 NCI Commands