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

SQL>create view persnl.salarylist

+>as select salary from persnl.employee;

--- SQL operation complete.

SQL>

To display the SQL status messages in SQLPlus look and feel, the -DhpnciLF property value

is set to SQLPlus. The SQLPlus look and feel appears as shown below:

Picked up _JAVA_OPTIONS: -DhpnciLF=SQLPlus

Welcome to the HP Neoview Command Interface 2.3

Connected to DataSource: TDM_Default_DataSource

SQL>create view persnl.salarylist

+>as select salary from persnl.employee;

View created.

SQL>

NOTE: The look and feel property value Oracle is supported for backward compatibility.

The -DhpnciLF property value for setting the Teradata look and feel is BTEQ. Setting this

property results in a Teradata personality for the status messages logged for all SQL operations

within NCI. The Teradata look and feel appears as shown below:

Picked up_JAVA_OPTIONS: -DhpnciLF=BTEQ

Welcome to the HP Neoview Command Interface 2.3

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 44)

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

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

• “Setting the Trace Option” (page 46)

If you do not set a look and feel, the default is Neoview SQL.

Postinstallation Procedures 43