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

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 64).
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 62)
• “Setting and Showing the Idle Timeout Value for the Session” (page 63)
• “Customizing the Standard Prompt” (page 63)
• “Setting and Showing the SQL Terminator” (page 64)
• “Displaying the Elapsed Time” (page 64)
• “Setting and Showing the Current Schema” (page 65)
• “Limiting the Result Set of a Query” (page 65)
• “Showing Information About SQL Database Objects” (page 65)
• “Displaying Executed Commands” (page 68)
• “Editing and Reexecuting a Command” (page 68)
• “Clearing the Interface Window” (page 68)
• “Obtaining Help” (page 68)
For more information about the NCI interface commands, see Appendix A (page 89).
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
62 Running Commands Interactively in the NCI