Neoview Script Guide (R2.2)

Supported Look-and-Feel Types

Currently, Neoview Script 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 Script Interface 2.2

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 -DhpnvsLF property value

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

Picked up _JAVA_OPTIONS: -DhpnvsLF=SQLPlus

Welcome to the HP Neoview Script Interface 2.2

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 -DhpnvsLF 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 Neoview Script. The Teradata look and feel appears as shown below:

Picked up_JAVA_OPTIONS: -DhpnvsLF=BTEQ

Welcome to the HP Neoview Script Interface 2.2

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>

36 Installing Neoview Script