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

*** Schema has been set.
*** Total elapsed time was 16 second(s).
SQL>select * from book;
*** Total Query time was 1 second.
BOOKID BOOKTITLE BOOKAUTHORID ISCHECKEDOUT
----------- ------------------------------ ------------ ------------
13333 UML Simplified 93333 0
11111 C++ Internals 91111 0
12222 Object Oriented Design 92222 0
*** Query completed. 3 rows found. 4 columns returned.
*** Total elapsed time was 1 second(s).
SQL>
To set the look and feel, see:
• “Setting the Look and Feel at a Command-Line Prompt” (page 26)
• “Setting the Look and Feel in the System Properties on Windows” (page 27)
• “Setting the Look and Feel in the User Profile on Linux or UNIX” (page 29)
• “Setting the Trace Option” (page 29)
If you do not set a look and feel, the default is Neoview SQL.
Setting the Look and Feel at a Command-Line Prompt
To set the _JAVA_OPTIONS environment variable for each session at a command-line prompt:
• On Windows, enter this command:
set _JAVA_OPTIONS=-DhpnciLF=look-and-feel-type
look-and-feel-type is one of the “Supported Look-and-Feel Types” (page 25). For
example:
set _JAVA_OPTIONS=-DhpnciLF=SQLPlus
set _JAVA_OPTIONS=-DhpnciLF=BTEQ
• On Linux or UNIX, enter this command:
export _JAVA_OPTIONS=-DhpnciLF=look-and-feel-type
look-and-feel-type is one of the “Supported Look-and-Feel Types” (page 25). For
example:
export _JAVA_OPTIONS=-DhpnciLF=SQLPlus
export _JAVA_OPTIONS=-DhpnciLF=BTEQ
To return to the default look and feel, Neoview SQL, set the -DhpnciLF property value to nci.
If you specify an invalid value, a warning message is displayed and the property value is set to
nci.
26 Installing and Configuring NCI