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

2. Enter the VERSION command to display information about the build versions:

SQL>version

Neoview Platform : N02.04.25.0

Neoview Connectivity Services : T7970N27_30SEP2008_SRV_0106

Neoview JDBC Type 4 Driver : T1249_N27(R2.4)_31MAR09_HP_JDBCT4_2009_03_10

Neoview Command Interface : T0774_N27(R2.4)_31MAR09_HP_NCI_2009_03_10

If not connected then NCI displays:

SQL>version

Neoview Platform : N02.04.25.0

Neoview Connectivity Services : T7970N27_30SEP2008_SRV_0106

Neoview JDBC Type 4 Driver : T1249_N27(R2.4)_31MAR09_HP_JDBCT4_2009_03_10

Neoview Command Interface : T0774_N27(R2.4)_31MAR09_HP_NCI_2009_03_10

SQL>

Setting the Look and Feel of NCI

To determine the look and feel of NCI, set the -DhpnciLF property by using the

_JAVA_OPTIONS environment variable. This property affects the formatting of status messages.

This property does not restrict the SQL statements, commands, or syntax that you can execute

in NCI. Each look-and-feel type accepts all the SQL statements, commands, and syntax that NCI

currently supports.

Supported Look-and-Feel Types

Currently, NCI supports the SQLPlus and Teradata look-and-feel types, in addition to the default

look and feel, Neoview SQL. The default look and feel, Neoview SQL, appears as shown below:

Welcome to the HP Neoview Command Interface 2.4

Connected to DataSource: TDM_Default_DataSource

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.4

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.4

Postinstallation Procedures 41