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

To terminate an SQL statement that spans multiple lines, use the SQL terminator for the session.
You can also include several SQL statements on the same command line provided that each one
is terminated by the SQL terminator. For more information, see “Setting and Showing the SQL
Terminator” (page 48).
Case Sensitivity
In the NCI interface, you can enter SQL statements and NCI interface commands in uppercase,
lowercase, or mixed-case characters. All parts of statements and commands are case-insensitive
except for parts that you enclose in single-quotes (') or double-quotes (").
Using NCI Interface Commands
The NCI interface commands allow you to customize the Neoview Command Interface (for
example, by using SET commands) or return information about the interface settings or database
objects (for example, by using SHOW commands):
• “Showing the Session Attributes” (page 46)
• “Setting and Showing the Idle Timeout Value for the Session” (page 47)
• “Customizing the Standard Prompt” (page 47)
• “Setting and Showing the SQL Terminator” (page 48)
• “Displaying the Elapsed Time” (page 48)
• “Setting and Showing the Current Schema” (page 49)
• “Limiting the Result Set of a Query” (page 49)
• “Showing Information About SQL Database Objects” (page 49)
• “Displaying Executed Commands” (page 52)
• “Editing and Reexecuting a Command” (page 52)
• “Clearing the Interface Window” (page 52)
• “Obtaining Help” (page 52)
For more information about the NCI interface commands, see Appendix A (page 71).
NOTE: Each NCI interface command must be entered on one line. If you accidentally break a
NCI interface command across more than one line, enter the SQL terminator and then reenter
the command on one line.
Showing the Session Attributes
To display the attributes and settings of the current NCI session, use the ENV, SHOW SESSION,
or SESSION command. For example, this SESSION command displays the session attributes:
SQL>session
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT DEFAULT [No expansion of script files]
IDLETIMEOUT 30 min(s)
LIST COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL NCI
MARKUP RAW
MODE SQL
PROMPT SQL>
ROLE DBA
SCHEMA USR
SERVER neo0101.acme.com:18650
SERVICE NAME HP_DEFAULT_SERVICE
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
46 Running Commands Interactively in NCI