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