HP NEOVIEW 544530-001 36

execute in the Neoview Script interface. Each look-and-feel type accepts all the SQL statements, commands, and syntax that Neoview Script currently supports.

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

SQL>create view persnl.salarylist

+>as select salary from persnl.employee;

--- SQL operation complete.

SQL>

The -DhpnvsLFproperty value for setting the SQLPlus look and feel is SQLPlus. The SQLPlus look and feel appears as shown below:

Picked up _JAVA_OPTIONS: -DhpnvsLF=SQLPlus

Welcome to the HP Neoview Script Interface 2.1

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 -DhpnvsLFproperty value for setting the Teradata look and feel is BTEQ. Setting this property results in a Teradata personality for the messages logged for all SQL operations within Neoview Script. The Teradata look and feel appears as shown below:

SQL>set schema sch;

***Schema has been set.

***Total elapsed time was 16 second(s).

SQL>select * from book;

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

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

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

36 Installing Neoview Script