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
(c) Copyright 2006, 2007 Hewlett-Packard Development Company, LP.
Connected to DataSource: TDM_Default_DataSource
SQL>create view persnl.salarylist
+>as select salary from persnl.employee;
--- SQL operation complete.
SQL>
The -DhpnvsLF property 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
(c) Copyright 2006, 2007 Hewlett-Packard Development Company, LP.
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 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