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

Connected to DataSource: TDM_Default_DataSource

SQL>set schema sch;

*** 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 42)

• “Setting the Look and Feel in the System Properties on Windows” (page 42)

• “Setting the Look and Feel in the User Profile on Linux or UNIX” (page 45)

• “Setting the Trace Option” (page 45)

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 41). 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 41). 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.

Setting the Look and Feel in the System Properties on Windows

1. Right-click the My Computer icon on your desktop and then select Properties.

2. In the System Properties dialog box, select the Advanced tab and click Environment

Variables.

42 Installing NCI