HP Neoview Script Guide
Copyright 2007 Hewlett-Packard Development Company, L.P
Table of Contents
Table of Contents
Running Scripts in the Neoview Script Interface
Exit Command
Example
114
137
Info DS Command 135 Syntax Considerations Example
133
135
Page
List of Figures
Page
List of Tables
Page
Document Organization
About This Document
Intended Audience
New and Changed Information in This Edition
General Syntax Notation
Notation Conventions
Related Documentation
Neoview Customer Library
Neoview Support Library
This manual is part of the Neoview customer library
HP Encourages Your Comments
Publishing History
Page
Neoview Script Within a Neoview Platform Network
Introduction to Neoview Script
Page
Installing a Supported Java Version
Installing Neoview Script
Preinstallation Procedures
Installing and Verifying the Java Runtime Environment JRE
Verifying the Java Version
Setting the Path to a Supported Java Version on Windows
Preinstallation Procedures
Installing and Verifying the Neoview Jdbc Type 4 Driver
Installing the Jdbc Driver
Verifying the Jdbc Driver
Perl version Python version
Installation Procedures
Installing Perl or Python
Downloading the Installer
To display the version of the downloaded installer file
Verifying the Version of the Installer File
Running the Installer
Installer Wizard Steps
Using the Installer Wizard
Installing Neoview Script
Installation Procedures
Installing Neoview Script
Command-Line Installation Steps
Verifying the Installed Software Files
Postinstallation Procedures
Setting the Look and Feel of the Neoview Script Interface
Verifying the Installed Version of Neoview Script
To set the look and feel, see
Supported Look-and-Feel Types
On Linux or UNIX, enter this command
Setting the Look and Feel at a Command-Line Prompt
DhpnvsLF=look-and-feel-type
Testing the Launch of Neoview Script
If you cannot connect to the database, verify that
Launching the Neoview Script Interface
Launching the Neoview Script Interface on Windows
Creating a Shortcut to hpnvs.cmd
Launching the Neoview Script Interface
Launching the Neoview Script Interface on Windows
Setting the Path of hpnvs.sh
Launching the Neoview Script Interface on Linux or Unix
Terminal window, enter
Enter your user name
Presetting the Optional Launch Parameters
Default Login
Logging In to the Database Platform
Using Optional Launch Parameters
Login Parameters
Logging In When Launching Neoview Script
Running a Command When Launching Neoview Script
On Linux or UNIX, in the terminal window, enter
Running a Script File When Launching Neoview Script
For more information, see Creating a Script File
Launching Neoview Script Without Connecting to the Database
Example of Launching Neoview Script File With -noconnect
Exiting the Neoview Script Interface
Interface Prompts
Breaking the Command Line
Neoview Script Interface
Product Banner
Using Neoview Script Interface Commands
Case Sensitivity
Showing the Session Attributes
For more information, see the SET Prompt Command
Setting and Showing the Idle Timeout Value for the Session
SET Prompt Command
SET Time Command
Setting and Showing the SQL Terminator
For more information, see the SET Time Command
Displaying the Elapsed Time
Showing Information About SQL Database Objects
Setting and Showing the Current Schema
For more information, see the SET Timing Command
Limiting the Result Set of a Query
Showing the Schemas
Showing the Tables in a Schema
Showing the Dependent Objects of a Table
For more information, see the Show Views Command
Showing the Views in a Schema
Showing the Synonyms in a Schema
For more information, see the Show Table Command
Obtaining Help
Displaying Executed Commands
Editing and Reexecuting a Command
Clearing the Interface Window
Running SQL Statements
Executing an SQL Statement
Repeating an SQL Statement
Preparing an SQL Statement
Preparing and Executing SQL Statements
This Select statement uses sal as a named parameter
Setting Parameters
Resetting the Parameters
Displaying the Parameters of the Session
Executing a Prepared SQL Statement
Spool on or LOG on Command
Logging Output
Starting the Logging Process
Stopping the Logging Process
Viewing the Contents of a Log File
Logging Output
Page
Creating a Script File
Running Scripts in the Neoview Script Interface
This script file creates tables in the inventory schema
Running a Script File
Example of a Script File
Running Scripts in Parallel
Obey command. For the Neoview Script bin directory, see -1
Running Scripts in the Neoview Script Interface
At each command prompt, enter one of these commands
Setting the Login Environment Variables
Setting the Login Environment Variables on Windows
Setting Login Environment Variables on the Command Line
Setting Login Environment Variables in the System Properties
Setting the Login Environment Variables on Linux or Unix
Perl and Python Wrapper Scripts
Setting Login Environment Variables in the User Profile
Command returns this output
Perl and Python Commands on Windows
Perl and Python Commands on Linux or Unix
On the Python command line, enter
Example of a Perl Program example.pl
Setting the Login Environment Variables
Using SQL Statements in a Perl or Python Program
Launching Neoview Script From a Perl or Python Program
Example of a Python Program example.py
Running the Perl or Python Program
Perl example.pl
See the @ Command
Neoview Script Interface Commands
RUN
Syntax
@ Command
Syntax Considerations
Command
Considerations
Examples
Clear Command
Connect Command
This Clear command clears the interface window
Disconnect Command
Colsep
ENV Command
Timing
Exit Command
Most recent command
FC Command
These results are logged when error code 4082 occurs
Matching the text to a command
Above the letter
Reexecute the most recent command that begins with SH
SQLselect * from persnl.employee
Help Command
History Command
This Help command shows help text for SET Idletimeout
Before logging new information to the file
LOG Command
You execute the LOG command
File in the Neoview Script bin directory
Mode Command
Obey Command
All other interface commands are disallowed in CS mode
SET Time and Show Time SET Timing and Show Timing
Drop Table Course
Prun Command
Parallelrunprun Summary
Quit Command
Blanks
Reconnect Command
Repeat Command
Repeat command reexecutes a previous command
Reset Param Command
Reexecute the fifth command in the history buffer
Reexecute the Show Tables command
RUN Command
Session history to the file
Savehist Command
SET Colsep Command
Savehist command
This SET Colsep command specifies the separator as a pipe
SET Histopt Command
C55,COMPUTER ARCH.,VON Neumanns MACH.,3,100,CIS
SET Idletimeout Command
SET Markup Command
To reset the default timeout value, enter this command
This command sets the idle timeout value to four hours
143,STEVENS Supply
SET Listcount Command
SET Param Command
This command sets a value for the ?sal salary parameter
SET Prompt Command
SET Sqlprompt Command
This command displays the session user name for the prompt
This command displays the session schema for the prompt
This command sets the SQL prompt to Enter
To reset the SQL prompt to the default, enter this command
Datasource displays the session data source as the prompt
SET Time Command
SET Sqlterminator Command
Show Colsep Command
SET Timing Command
This command displays the value set for the history option
Show Histopt Command
Show Idletimeout Command
This Show Colsep command displays the column separator
Show Markup Command
Show Listcount Command
For more information, see Mode Command
Show Mode Command
Show Mvgroups Command
This command displays the value set for the markup option
Show MVS Command
Show Param Command
Show Prepared Command
Show Schemas Command
Show Schema Command
For more information, see Showing the Schemas
Show Session Command
Show Sqlprompt Command
Show Synonyms Command
Show Sqlterminator Command
Show Table Command
Qualify the materialized-view-name, Neoview Script
Table-name, Neoview Script uses the current schema
Uses the current schema
Specifies the name of a table. If you do not fully qualify
This command shows all information of the EMP table
Show Tables Command
Show Time Command
Show Views Command
Show Timing Command
Spool Command
You execute the Spool command
Version Command
Example
Create Mvgroup
Supported SQL Statements
Insert
Connectivity Service Commands
Info DS Command
Terms used in the Info DS reports are
Available servers for this service on this data source
Index
Symbols
Index
139
SET Schema
141