Manuals / HP / Computer Equipment / Computer Accessories

HP NEOVIEW 544530-001 manual

Models: NEOVIEW 544530-001

1 142

Download 142 pages 61.21 Kb

Page 20

20

Image 20

HP NEOVIEW 544530-001 manual

Contents

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 Info DS Command 135 Syntax Considerations Example 133135 137Page List of Figures Page List of Tables Page About This Document Intended AudienceNew and Changed Information in This Edition Document OrganizationNotation Conventions General Syntax NotationRelated Documentation This manual is part of the Neoview customer library Neoview Customer LibraryNeoview Support Library Publishing History HP Encourages Your CommentsPage Introduction to Neoview Script Neoview Script Within a Neoview Platform NetworkPage Installing Neoview Script Preinstallation ProceduresInstalling and Verifying the Java Runtime Environment JRE Installing a Supported Java VersionSetting the Path to a Supported Java Version on Windows Verifying the Java VersionPreinstallation Procedures Verifying the Jdbc Driver Installing and Verifying the Neoview Jdbc Type 4 DriverInstalling the Jdbc Driver Installation Procedures Installing Perl or PythonDownloading the Installer Perl version Python versionVerifying the Version of the Installer File Running the InstallerInstaller Wizard Steps To display the version of the downloaded installer fileUsing the Installer Wizard Installing Neoview Script Installation Procedures Installing Neoview Script Command-Line Installation Steps Postinstallation Procedures Verifying the Installed Software FilesVerifying the Installed Version of Neoview Script Setting the Look and Feel of the Neoview Script InterfaceSupported Look-and-Feel Types To set the look and feel, seeSetting the Look and Feel at a Command-Line Prompt On Linux or UNIX, enter this commandDhpnvsLF=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 InterfaceLaunching 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.shLaunching the Neoview Script Interface on Linux or Unix Presetting the Optional Launch Parameters Default LoginLogging In to the Database Platform Enter your user nameLogin Parameters Using Optional Launch ParametersOn Linux or UNIX, in the terminal window, enter Logging In When Launching Neoview ScriptRunning a Command When Launching Neoview Script Running a Script File When Launching Neoview Script Launching Neoview Script Without Connecting to the Database For more information, see Creating a Script FileExiting the Neoview Script Interface Example of Launching Neoview Script File With -noconnectBreaking the Command Line Neoview Script InterfaceProduct Banner Interface PromptsShowing the Session Attributes Using Neoview Script Interface CommandsCase Sensitivity Setting and Showing the Idle Timeout Value for the Session SET Prompt CommandSET Time Command For more information, see the SET Prompt CommandDisplaying the Elapsed Time Setting and Showing the SQL TerminatorFor more information, see the SET Time Command Setting and Showing the Current Schema For more information, see the SET Timing CommandLimiting the Result Set of a Query Showing Information About SQL Database ObjectsShowing the Dependent Objects of a Table Showing the SchemasShowing the Tables in a Schema Showing the Views in a Schema Showing the Synonyms in a SchemaFor more information, see the Show Table Command For more information, see the Show Views CommandDisplaying Executed Commands Editing and Reexecuting a CommandClearing the Interface Window Obtaining HelpRepeating an SQL Statement Running SQL StatementsExecuting an SQL Statement Preparing and Executing SQL Statements Preparing an SQL StatementSetting Parameters Resetting the ParametersDisplaying the Parameters of the Session This Select statement uses sal as a named parameterExecuting a Prepared SQL Statement Starting the Logging Process Spool on or LOG on CommandLogging Output Viewing the Contents of a Log File Stopping the Logging ProcessLogging Output Page Running Scripts in the Neoview Script Interface Creating a Script FileExample of a Script File This script file creates tables in the inventory schemaRunning a Script File Obey command. For the Neoview Script bin directory, see -1 Running Scripts in ParallelRunning Scripts in the Neoview Script Interface Setting the Login Environment Variables Setting the Login Environment Variables on WindowsSetting Login Environment Variables on the Command Line At each command prompt, enter one of these commandsSetting Login Environment Variables in the System Properties Setting the Login Environment Variables on Linux or Unix Setting Login Environment Variables in the User Profile Perl and Python Wrapper ScriptsPerl and Python Commands on Windows Perl and Python Commands on Linux or UnixOn the Python command line, enter Command returns this outputSetting the Login Environment Variables Using SQL Statements in a Perl or Python ProgramLaunching Neoview Script From a Perl or Python Program Example of a Perl Program example.plRunning the Perl or Python Program Example of a Python Program example.pyPerl example.pl Neoview Script Interface Commands See the @ CommandRUN @ Command SyntaxCommand ConsiderationsExamples Syntax ConsiderationsThis Clear command clears the interface window Clear CommandConnect Command Disconnect Command ENV Command ColsepExit Command TimingFC Command These results are logged when error code 4082 occursMatching the text to a command Most recent commandReexecute the most recent command that begins with SH Above the letterSQLselect * from persnl.employee This Help command shows help text for SET Idletimeout Help CommandHistory Command LOG Command You execute the LOG commandFile in the Neoview Script bin directory Before logging new information to the fileMode Command SET Time and Show Time SET Timing and Show Timing Obey CommandAll other interface commands are disallowed in CS mode Drop Table Course Prun Command Parallelrunprun Summary Quit Command Reconnect Command Repeat CommandRepeat command reexecutes a previous command BlanksReexecute the Show Tables command Reset Param CommandReexecute the fifth command in the history buffer RUN Command Savehist Command SET Colsep CommandSavehist command Session history to the fileSET Histopt Command This SET Colsep command specifies the separator as a pipeSET Idletimeout Command C55,COMPUTER ARCH.,VON Neumanns MACH.,3,100,CISThis command sets the idle timeout value to four hours SET Markup CommandTo 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 CommandThis 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 EnterTo reset the SQL prompt to the default, enter this command SET Sqlterminator Command SET Time CommandSET Timing Command Show Colsep CommandShow Histopt Command Show Idletimeout CommandThis Show Colsep command displays the column separator This command displays the value set for the history optionShow Listcount Command Show Markup CommandShow Mode Command Show Mvgroups CommandThis command displays the value set for the markup option For more information, see Mode CommandShow MVS Command Show Param Command Show Prepared Command Show Schema Command Show Schemas CommandFor more information, see Showing the Schemas Show Session Command Show Sqlprompt Command Show Sqlterminator Command Show Synonyms CommandShow Table Command Table-name, Neoview Script uses the current schema Uses the current schemaSpecifies the name of a table. If you do not fully qualify Qualify the materialized-view-name, Neoview ScriptShow Tables Command This command shows all information of the EMP tableShow Time Command Show Timing Command Show Views CommandSpool Command Version Command You execute the Spool commandExample Supported SQL Statements Create MvgroupInsert Terms used in the Info DS reports are Connectivity Service CommandsInfo DS Command Available servers for this service on this data source Symbols IndexIndex 139 SET Schema 141