HP 544530-001 - Manuals - manualsarea.com

Page 3 - About This Document

Table of Contents About This Document ....................................................................................................... 15 Intended Audience................................................................................................................................15New and ...

Page 11 - List of Figures

List of Figures 1-1 Neoview Script Within a Neoview Platform Network.................................................................21 11

Page 13 - List of Tables

List of Tables 2-1 Locations of Neoview Script Software Files..................................................................................34 13

Page 15 - Intended Audience; Document Organization

About This Document This manual describes how to use the Neoview Script command-line interface on a clientworkstation to manage a database on a Neoview data warehousing platform. Neoview Scriptenables you to perform daily administrative tasks by running SQL statements interactively orfrom script fil...

Page 16 - Notation Conventions; General Syntax Notation; UPPERCASE LETTERS

Describes how to run Neoview Script from Perl or Python. Chapter 6: Running NeoviewScript From Perl or Python Provides syntax, considerations, and examples for Neoview Script interfacecommands. Appendix A: Neoview ScriptInterface Commands Lists the SQL statements that Neoview Script supports. Append...

Page 17 - “Neoview Customer Library”

| Vertical Line A vertical line separates alternatives in a horizontal list that is enclosedin brackets or braces. For example: {expression | NULL} … Ellipsis An ellipsis immediately following a pair of brackets or braces indicatesthat you can repeat the enclosed sequence of syntax items any numbero...

Page 18 - Neoview Customer Library; This manual is part of the Neoview customer library:; Administration; Neoview Support Library

Neoview Customer Library This manual is part of the Neoview customer library: • Administration Information about how to load and manage the Neoview databaseby using the Neoview DB Admin and other tools. Neoview Database Administrator’s Guide Context-sensitive help topics that describe how to use the...

Page 19 - Publishing History; HP Encourages Your Comments

Installation and replacement procedures. Neoview Hardware Installation and SupportGuide Information on managing and configuring Dashboard from theDashboard Server and Client, including starting and runningDashboard, using Discrete Object Thresholds (DOTs), using DashboardCommand Interpreter commands...

Page 21 - Introduction to Neoview Script; Figure 1-1 Neoview Script Within a Neoview Platform Network

1 Introduction to Neoview Script Neoview Script is a command-line interface that you download and install on a client workstationthat has the Neoview JDBC Type 4 Driver installed. Operating systems that support the JDBCdriver include Windows, Linux, and UNIX. The JDBC driver connects Neoview Script ...

Page 23 - Installing Neoview Script; To install Neoview Script, follow these procedures:; Installing and Verifying the Java Runtime Environment (JRE); These Java versions are not supported:; Installing a Supported Java Version

2 Installing Neoview Script NOTE: If you are manually installing Neoview Script on a Linux platform that has the Neoview data loader installed, use the services or sysadmin ID instead of root, which has been frozen forthe loader. The best way to install Neoview Script on the loader platform is by us...

Page 24 - After installing the Java version, proceed with; Verifying the Java Version; If the returned version is not supported or is unavailable, see:; Setting the PATH to a Supported Java Version on Windows; In the System Properties dialog box, click the Advanced tab.

After installing the Java version, proceed with “Verifying the Java Version” (page 24) . Verifying the Java Version To display the Java version of the client workstation on the screen, enter: java -version For example: C:\>java -versionjava version "1.4.2_10"Java(TM) 2 Runtime Environment...

Page 26 - Setting the PATH to a Supported Java Version on Linux or UNIX; bin; Installing and Verifying the Neoview JDBC Type 4 Driver; Installing the JDBC Driver

5. Place the cursor at the beginning of the Variable Value field and type the path of the Java bin directory, ending with a semicolon (;): For example: "C:\Program Files\Java\j2re1.4.2_10\bin"; NOTE: Check that no space is after the semicolon (;) in the path. If there are spaces in the direc...

Page 27 - Installing Perl or Python; samples; “Preinstallation Procedures”; Downloading the Installer

1. Change the directory to the lib directory, which contains the JDBC driver JAR file: • On Windows, enter this command: cd jdbc-installation-directory\lib jdbc-installation-directory is the directory where you installed the JDBC driver. • On Linux or UNIX, enter this command: cd jdbc-installation-d...

Page 28 - Verifying the Version of the Installer File; Running the Installer; Installer Wizard Steps; Launching the Installer Wizard

1. Locate or create a directory or folder for the installer file anywhere on the client workstation. 2. On the client workstation, start a Web browser and navigate to the download site: http://www.software.hp.com 3. Enter “Neoview Script” in the search box in the upper right corner of the Software D...

Page 29 - is the directory where you downloaded the installer file,; Select the lib folder of the JDBC driver, and then click Open:

5. At a command prompt, change to the directory where you downloaded the installer: cd installer-directory installer-directory is the directory where you downloaded the installer file, hpnvsInstaller.jar . 6. Launch the Installer Wizard by entering: java -jar hpnvsInstaller.jar 7. Proceed to “Using ...

Page 32 - Click Install to start the installation:

The Installer Wizard displays the directory where the Neoview Script will be installed. 6. Click Install to start the installation: 32 Installing Neoview Script

Page 33 - Click OK, and proceed with; “Verifying the Installed Software Files” (page 34); Command-Line Installation Steps; is the directory where you downloaded the installer.

The Installation Status dialog box appears on the screen, indicating how many files areinstalled in the installation directory: The number of files that are extracted and installed is 15. All these files are stored in the nvscript subdirectory within the installation directory. 7. Click OK, and proc...

Page 34 - nvscript; Postinstallation Procedures; Verifying the Installed Software Files; After downloading and running the installer file,

4. Enter an existing directory where you would like to install Neoview Script: HP Neoview Script--------------------------------------Enter the installation directory: c:\install The installation status appears, indicating how many files are installed in the installationdirectory: HP Neoview Script-...

Page 35 - Table 2-1 Locations of Neoview Script Software Files; Verifying the Installed Version of Neoview Script; lib; Setting the Look and Feel of the Neoview Script Interface

Table 2-1 Locations of Neoview Script Software Files (continued) Description Files Directory Beta version of sample Perl program 1 sample-beta.pl Beta version of sample Pythonprogram 1 sample-beta.py 1 Neoview Script provides a beta version of enhanced support for Perl and Python programs. This func...

Page 37 - If you do not set a look and feel, the default is Neoview SQL.; Setting the Look and Feel at a Command-Line Prompt; is one of the; Setting the Look and Feel in the System Properties on Windows

If you do not set a look and feel, the default is Neoview SQL. Setting the Look and Feel at a Command-Line Prompt To set the _JAVA_OPTIONS environment variable for each session at a command-line prompt: • On Windows, enter this command: set _JAVA_OPTIONS=-DhpnvsLF=look-and-feel-type look-and-feel-ty...

Page 39 - nvs; Setting the Look and Feel in the User Profile on Linux or UNIX; export; Testing the Launch of Neoview Script

6. In the System Properties dialog box, click OK to accept the changes. To return to the default look and feel, Neoview SQL, set the -DhpnvsLF property value to nvs . Setting the Look and Feel in the User Profile on Linux or UNIX 1. Open the user profile ( .profile or .bash_profile for the Bash shel...

Page 41 - Launching the Neoview Script Interface; Find the Windows launch file,; Creating a Shortcut to hpnvs.cmd

3 Launching the Neoview Script Interface This chapter describes how to launch the Neoview Script interface from the Windows, Linux, orUNIX environment: • “Launching the Neoview Script Interface on Windows” (page 41) • “Launching the Neoview Script Interface on Linux or UNIX” (page 44) • “Logging In ...

Page 42 - Type the location of; within double quotes (“) or click Browse to locate that file,; For the location of the Neoview Script software files, see; Type a name for the shortcut and click Finish:

2. Type the location of hpnvs.cmd within double quotes (“) or click Browse to locate that file, and then click Next: For the location of the Neoview Script software files, see Table 2-1 (page 34) . 3. Type a name for the shortcut and click Finish: 42 Launching the Neoview Script Interface

Page 43 - In the Target box, insert a space after

4. If desired, specify optional launch parameters for the shortcut:a. Right-click the shortcut icon and select Properties: b. Click the Shortcut tab. c. In the Target box, insert a space after "...\nvscript\bin\hpnvs.cmd" and add the optional launch parameters: Launching the Neoview Script I...

Page 44 - Launching the Neoview Script Interface on Linux or UNIX; Setting the PATH of hpnvs.sh

For more information, see “Using Optional Launch Parameters” (page 46) . d. Click OK. 5. To launch Neoview Script, double-click the shortcut icon. The Neoview Script interface appears. If you did not set the optional launch parameters,the Neoview Script interface prompts you to enter the host name o...

Page 45 - Presetting the Optional Launch Parameters; hpnvs; Default Login

hpnvs-installation-directory is the directory where you installed the Neoview Script software files. For more information, see Table 2-1 (page 34) . Check that no space is after the colon (:) in the path. NOTE: In the C shell, use the setenv command instead of export . 3. To activate the changes, ei...

Page 46 - Login Parameters; when launching Neoview Script.; Using Optional Launch Parameters

3. Enter your password. 4. Enter the name of a data source that is available and running (that is, started). If you do not enter a data source, Neoview Script connects to Admin_Load_DataSource by default. Admin_Load_DataSource is the recommended data source for Neoview Script connections. If Admin_L...

Page 47 - Logging In When Launching Neoview Script; “Presetting the Optional Launch Parameters” (page 45); Running a Command When Launching Neoview Script

Description Launch Parameter Specifies that an SQL statement or a Neoview Scriptinterface command be run when launching the NeoviewScript interface. You cannot specify this parameter at thesame time as the -s or -script parameter. For more information, see “Running a Command When Launching Neoview S...

Page 48 - Running a Script File When Launching Neoview Script

Although you can run any of the Neoview Script interface commands with -q or -sql , the @, OBEY, and PRUN commands are the most useful. For a list of supported SQL statements, see Appendix B (page 133) . Example of Running an SQL Statement With -q or -sql Use -q or -sql with the CREATE SCHEMA statem...

Page 49 - Launching Neoview Script Without Connecting to the Database

DISCONNECT command. To quit the interface immediately after executing a script file, includethe EXIT, QUIT, or DISCONNECT command at the end of the script file. Example of a Script File You can create a script file that contains SET commands that customize a session when youlaunch Neoview Script: Fo...

Page 50 - Example of Launching Neoview Script File With -noconnect; Exiting the Neoview Script Interface; EXIT

Example of Launching Neoview Script File With -noconnect • On Windows, in the Command Prompt window, enter: cd hpnvs-installation-directory\nvscript\bin hpnvs.cmd -noconnect • On Linux or UNIX, in the terminal window, enter: cd hpnvs-installation-directory/nvscript/bin ./hpnvs.sh -noconnect Exiting ...

Page 51 - “Using Neoview Script Interface Commands” (page 52); Product Banner; Breaking the Command Line

4 Running Commands Interactively in the Neoview Script Interface After launching the Neoview Script interface, you can run SQL statements and Neoview Scriptinterface commands in the interface. • “Neoview Script Interface” (page 51) • “Using Neoview Script Interface Commands” (page 52) • “Running SQL...

Page 52 - Case Sensitivity; Using Neoview Script Interface Commands; Showing the Session Attributes

You can continue any SQL statement over multiple lines, breaking that statement at any pointexcept within a word, a numeric literal, or a multicharacter operator (for example, <=). To breaka string literal in a DML statement, use a concatenation operator (||). For more information, seethe concate...

Page 53 - “SHOW SESSION Command”; Setting and Showing the Idle Timeout Value for the Session; “SHOW; Customizing the Standard Prompt; SET PROMPT Command; SQL; SET TIME Command

SCHEMA USRSERVER neo0101.acme.com:18650SQLTERMINATOR ;TIME OFFTIMING OFFUSER role.dba SQL> For more information, see the “ENV Command” (page 85) or “SHOW SESSION Command” (page 122) . Setting and Showing the Idle Timeout Value for the Session The idle timeout value of a session determines when th...

Page 54 - Setting and Showing the SQL Terminator; For more information, see the; Displaying the Elapsed Time

20:32:26 SQL ENTER>set time off SQL ENTER> For more information, see the “SET TIME Command” (page 112) . Setting and Showing the SQL Terminator The SQL terminator symbolizes the end of an SQL statement. By default, the SQL terminator isa semicolon (;). To change the SQL terminator, enter the S...

Page 55 - Setting and Showing the Current Schema; SCHEMA PERSNL; Limiting the Result Set of a Query; Showing Information About SQL Database Objects; “Showing the Tables in a Schema” (page 56)

SQL> For more information, see the “SET TIMING Command” (page 113) . Setting and Showing the Current Schema By default, the schema of the session is USR. The SQL statement, SET SCHEMA, allows you toset the schema for the Neoview Script session. For example, this SET SCHEMA statement changesthe de...

Page 56 - Showing the Schemas; Showing the Tables in a Schema; Showing the Dependent Objects of a Table

• “Showing the Views in a Schema” (page 57) • “Showing the Synonyms in a Schema” (page 57) Showing the Schemas The SHOW SCHEMAS command displays the schemas that exist in the default catalog: SQL>show schemas SCHEMA NAMES----------------------------------------------------------------------------...

Page 57 - Showing the Views in a Schema; Showing the Synonyms in a Schema

SQL> For more information, see the “SHOW TABLE Command” (page 125) . Showing the Views in a Schema The SHOW VIEWS command displays the views that exist in the current schema. For example,this SHOW VIEWS command displays all the views in the current schema, INVENT: SQL>set schema invent; --- SQ...

Page 58 - Displaying Executed Commands; “Editing and; Editing and Reexecuting a Command

For more information, see the “SHOW SYNONYMS Command” (page 124) . Displaying Executed Commands To display commands that were recently executed in the Neoview Script session, enter theHISTORY command. The HISTORY command associates each command with a number thatyou can use to reexecute or edit the ...

Page 59 - This subsection shows examples of:; Executing an SQL Statement

Running SQL Statements In the Neoview Script interface, you can run SQL statements interactively. For a list of SQLstatements that you can run interactively, see Appendix B (page 133) . This subsection shows examples of: • “Executing an SQL Statement” (page 59) • “Repeating an SQL Statement” (page 5...

Page 60 - “REPEAT; Preparing and Executing SQL Statements; “Displaying the Parameters of the Session” (page 61); Preparing an SQL Statement; empsal

SQL> For more information, see the “/ Command” (page 82) , “RUN Command” (page 100) , or “REPEAT Command” (page 98) . Preparing and Executing SQL Statements You can prepare, or compile, an SQL statement by using the PREPARE statement and laterexecute the prepared SQL statement by using the EXECUT...

Page 61 - Setting Parameters; findemp; Displaying the Parameters of the Session

Setting Parameters In a Neoview session, you can set a parameter of an SQL statement (either prepared or not) byusing the SET PARAM command. NOTE: The parameter name is case-sensitive. If you specify it in lowercase in the SET PARAM command, you must specify it in lowercase in other statements, such...

Page 62 - Executing a Prepared SQL Statement

dn 1500sal 80000.00 SQL> For the syntax of the RESET PARAM command, see the “RESET PARAM Command” (page 99) . Executing a Prepared SQL Statement To execute a prepared SQL statement, use the EXECUTE statement. For example, this EXECUTE statement executes the prepared empsal statement, which does n...

Page 63 - “Viewing the Contents of a Log File” (page 64); Starting the Logging Process; SPOOL ON or LOG ON Command

TED MCDONALD 2000 PETER SMITH 3300 MARK FOLEY 4000 HEIDI WEIGL 3200 ROCKY LEWIS 2000 SUE CRAMER 1000 MARTIN SCHAEFFER 3200 HERBERT KARAJAN 3200 JESSICA CRINER 3500 --- 35 row(s) selected. SQL> This EXECUTE statement executes the prepared findemp statement, which has two unnamed parameters: ?sal ,...

Page 64 - Using the CLEAR Option; Stopping the Logging Process

hpnvs-installation-directory is the directory where you installed the Neoview Script software files. For more information, see Table 2-1 (page 34) . • On Linux or UNIX: hpnvs-installation-directory/nvscript/bin/sqlspool.lst hpnvs-installation-directory is the directory where you installed the Neovie...

Page 67 - Running Scripts in the Neoview Script Interface; “Supported SQL Statements in Script Files” (page 67); Supported SQL Statements in Script Files; Disallowed Interface Commands in Script Files; Comments

5 Running Scripts in the Neoview Script Interface In the Neoview Script interface, you can run script files. • “Creating a Script File” (page 67) • “Running a Script File” (page 68) • “Logging Output” (page 69) • “Running Scripts in Parallel” (page 69) Creating a Script File A script file that you r...

Page 68 - or the; Example of a Script File; This script file creates tables in the inventory schema:; Running a Script File; “Running a Script File When Launching Neoview Script”

the section name in the @ or OBEY command. For more information, see the “@ Command” (page 81) or the “OBEY Command” (page 93) . Example of a Script File This script file creates tables in the inventory schema: Running a Script File To run a script file in the Neoview Script interface, use the @ or ...

Page 70 - “PRUN

NOTE: Starting with the 2.1 release, the PRUN command can be run in non-interactive mode. The PRUN command now allows options to be specified on the command line, which enablesPRUN to be run in script and/or obey files. The PRUN command is most useful for running sets of data definition language (DD...

Page 71 - Running Neoview Script From Perl or Python; “Setting the Login Environment Variables” (page 71); “Setting the Login Environment Variables on Windows” (page 71); Setting the Login Environment Variables on Windows; Setting Login Environment Variables on the Command Line; At each command prompt, enter one of these commands:

6 Running Neoview Script From Perl or Python You can execute an SQL statement in Perl or Python by invoking the Neoview Script Perl orPython wrapper script. To use the Perl or Python wrapper script, see: • “Setting the Login Environment Variables” (page 71) • “Perl and Python Wrapper Scripts” (page ...

Page 72 - Setting Login Environment Variables in the System Properties

set HPNVS_PASSWORD=passwordset HPNVS_DATASOURCE=data-source-name Setting Login Environment Variables in the System Properties 1. Right-click the My Computer icon on your desktop, and then select Properties: 2. In the System Properties dialog box, click the Advanced tab. 3. Click the Environment Vari...

Page 73 - Setting the Login Environment Variables on Linux or UNIX

4. In the Environment Variables dialog box, click New under System or User variables,whichever you prefer. 5. In the New User Variable dialog box, type the name of the login environment variable forthe Variable Name and the required value for the Variable Value, and then click OK: 6. Verify that the...

Page 74 - Setting Login Environment Variables in the User Profile; Perl and Python Wrapper Scripts; Launching Neoview Script From the Perl or Python Command Line

export HPNVS_SERVER=host-name:port-numberexport HPNVS_USER=user-nameexport HPNVS_PASSWORD=passwordexport HPNVS_DATASOURCE=data-source-name At each command prompt in the C shell, enter one of these commands: setenv HPNVS_SERVER=host-name:port-numbersetenv HPNVS_USER=user-namesetenv HPNVS_PASSWORD=pas...

Page 75 - Perl and Python Commands on Windows

You can pass only one SQL statement at a time on the Perl or Python command line. The SQLstatement must: • Be enclosed in double quotes (") without the SQL terminator (;) • Contain fully qualified database object names (for example, neo.schema-name.obj-name ) • Contain the syntax of one of the s...

Page 76 - The command returns this output:; Launching Neoview Script From a Perl or Python Program; perl; “Setting the Login Environment Variables”; Using SQL Statements in a Perl or Python Program; Contain fully qualified database object names (for example,

For example: >cd /usr/local/hp/nvscript/bin>perl hpnvs.pl "POPULATE INDEX neo.persnl.xempname >ON neo.persnl.employee" • On the Python command line, enter: cd hpnvs-installation-directory/nvscript/binpython hpnvs.py "sql-statement-string" For example: >cd /usr/local/hp/nv...

Page 77 - Running the Perl or Python Program; or

#-----Reorganize the table --------------------------------------------------$status=`perl /usr/local/hp/nvscript/bin/hpnvs.pl "$reorgtable"`;print "Reorg status :".$status;print "\n"; #----------Update the statistics of the table--------------------------------$status=`perl ...

Page 79 - A Neoview Script Interface Commands

A Neoview Script Interface Commands Neoview Script supports these commands in the Neoview Script interface or in script files thatyou run in the Neoview Script interface. For a list of Neoview Script interface commands thatare available only to HP support, see the Neoview Database Support Guide. Syn...

Page 82 - Considerations

script-file is the name of an ASCII text file that contains SQL statements, NeoviewScript interface commands, and comments. If the script file exists outsidethe local directory where you launch Neoview Script (by default, theNeoview Script bin directory), specify the full directory path of the scrip...

Page 83 - This CLEAR command clears the interface window:; CONNECT Command; launch parameter, you are prompted for a

SQL>/ (EXPR) -------------------- 62 --- 1 row(s) selected. SQL> CLEAR Command The CLEAR command clears the interface window so that only the prompt appears at the topof the window. CLEAR does not clear the log file or reset the settings of the session. Syntax CLEAR Considerations In the Neovi...

Page 84 - Examples; DISCONNECT Command

If Neoview Script was invoked with the -noconnect launch parameter, Neoview Script prompts you for the values.Currently, none of the commands work with the -noconnect option. Examples These commands create a new connection to the Neoview platform from the current or existingNeoview Script interface:...

Page 85 - ENV Command; ENV displays these attributes:

ENV Command ENV displays attributes of the current Neoview Script session. You can also use the SESSIONand SHOW SESSION commands to perform the same function. Syntax ENV Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL termi...

Page 86 - This ENV command displays the attributes of the current session:; EXIT Command

Current setting (on or off) of the elapsed time. By default, the elapsed time is off.For more information, see “Displaying the Elapsed Time” (page 54) and “SET TIMING Command” (page 113) . TIMING User name that you entered when logging in to the database platform. For moreinformation, see “Logging I...

Page 87 - These results are logged when error code 4082 occurs:; text

error-code is an integer that represents an error condition of the previously executedcommand. If the previously executed command returns this error code, theNeoview Script interface disconnects and exits.Commands that execute successfully in the Neoview Script interface have anerror code of zero (0...

Page 88 - Reexecute the most recent command that begins with SH:

Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • You cannot execute this command in a script file. You can execute this command only at acommand prompt. • As each line of the command is displayed, you can modif...

Page 90 - HELP Command; This HELP command shows help text for SET IDLETIMEOUT:; HISTORY Command

SQL>where jobcode=450;.... Pressing Enter lists the employee number and last names of all employees whose job codeis 450: EMPNUM LAST_NAME ------ -------------------- 180 CONRAD 215 LANCASTER 216 JONES 225 HELMSTED 232 SPINNER --- 5 row(s) selected. SQL> HELP Command The HELP command displays ...

Page 91 - number; “FC Command”; Example

Syntax HISTORY [number] number is the number of commands to display. The default number is 10. The maximumnumber is 100. Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • You can use the FC command to edit and r...

Page 92 - MODE Command

Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • Use a unique name for each log file to avoid writing information from different NeoviewScript sessions into the same log file. Examples • This command starts the...

Page 94 - Put a space between OBEY and the first character of the file name.; To run only the commands in section create, execute the following :

Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • Put a space between OBEY and the first character of the file name. • You can execute this command in a script file. • You can specify only one script file at a t...

Page 95 - The PRUN command runs script files in parallel.; scriptsdir

+> CNO VARCHAR(3) NOT NULL,+> CNAME VARCHAR(22) NOT NULL,+> CDESCP VARCHAR(25) NOT NULL, +> CRED INT,+> CLABFEE NUMERIC(5,2),+> CDEPT VARCHAR(4) NOT NULL,+> primary key (cno)+>) ; --- SQL Operation complete. To run only the commands in the insert section, execute the followin...

Page 98 - RECONNECT Command; launch parameter, Neoview Script prompts; REPEAT Command; The REPEAT command reexecutes a previous command.

log c:\errorCode.logselect * from employee;quit if errorcode=4082log off These results are logged when error code 4082 occurs: SQL>select * from employee; *** ERROR[4082] Table, view or stored procedure NEO.USR.EMPLOYEE does not exist or is inaccessible.*** ERROR[8822] The statement was not prepa...

Page 99 - Reexecute the fifth command in the history buffer:

Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • To reexecute the immediately preceding command, enter REPEAT without specifying anumber. If you enter more than one command on a line, the REPEAT command reexecu...

Page 100 - RUN Command; You can execute this command only in SQL mode.

Syntax RESET PARAM [param-name] param-name is the name of the parameter for which you specified a value. Parameter namesare case-sensitive. For example, the parameter ?pn is not equivalent to theparameter ?PN. param-name can be preceded by a question mark (?), such as ?param-name . If you do not spe...

Page 101 - For more information, see; SET COLSEP Command

-------------------- 62 --- 1 row(s) selected. SQL> SAVEHIST Command The SAVEHIST command saves the session history in a user-specified file. The session historyconsists of a list of the commands that were executed in the Neoview Script session before theSAVEHIST command. Syntax SAVEHIST file-nam...

Page 102 - This SET COLSEP command specifies the separator as a; SET HISTOPT Command

to use for separating columns in each row of the results. The default delimiter is “ ” (white space). Syntax SET COLSEP [separator] Considerations In the Neoview Script interface, you must enter the command on one line. The SET COLSEPcommand can be executed only in SQL mode.The SET COLSEP command ha...

Page 103 - value

--- SQL operation complete. SQL> INSERT INTO COURSE1 VALUES+> ('C11', 'INTRO TO CS','FOR ROOKIES',3, 100,'CIS'); --- 1 row(s) inserted. SQL> INSERT INTO COURSE1 VALUES+> ('C55', 'COMPUTER ARCH.','VON NEUMANN''S MACH.',3, 100, 'CIS'); --- 1 row(s) inserted. SQL> history;1> show hist...

Page 104 - To reset the default timeout value, enter this command:; This command sets the idle timeout value to four hours:; To reset the idle timeout to the default, enter this command:; SET MARKUP Command; This SET MARKUP command specifies results be displayed in HTML:

Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • If you execute this command in a script file, it affects the session in which the script file runs.You can specify this command in PRUN script files. However, ru...

Page 106 - SET LIST_COUNT Command

<Results><Query> <![CDATA[select * from author;]]></Query><rowid="1"> <AUTHORID>91111</AUTHORID> <AUTHORNAME>Bjarne Stroustrup</AUTHORNAME> </row> <rowid="2"> <AUTHORID>444444</AUTHORID> <AUTHORNAME>J...

Page 109 - string

NOTE: The names of the named parameters, ?sal and ?job , in the SELECT statement are identical to the parameter names, sal and job , in the SET PARAM command. For more information, see “Setting Parameters” (page 61) . SET PROMPT Command The SET PROMPT command sets the prompt of the current session t...

Page 110 - “Customizing the Standard Prompt” (page 53); SET SQLPROMPT Command

SQL> • This command displays the session user name for the prompt: SQL>set prompt %user> dba1> • This command displays the operating mode of the session for the prompt: SQL>set prompt %mode: SQL: • This command displays the session host name and port number for the prompt: SQL>set ...

Page 112 - SET SQLTERMINATOR Command; “Setting and Showing the SQL Terminator ” (page 54)

SET SQLTERMINATOR Command The SET SQLTERMINATOR command sets the SQL statement terminator of the current session.The default is a semicolon (;). Syntax SET SQLTERMINATOR string string is a string value for the SQL terminator. The string may contain any characters exceptspaces. Spaces are disallowed ...

Page 113 - SHOW COLSEP Command

Starting with the R2.1 release, the default is a 24–hour military style display. The additionalargument of 12h allows the time to be displayed in a 12–hour AM/PM style. Examples • This command causes the local time to be displayed in the SQL prompt: SQL>set time on 14:17:17 SQL> • This command...

Page 114 - This SHOW COLSEP command displays the column separator.; SHOW HISTOPT Command; This command displays the value set for the history option:; SHOW IDLETIMEOUT Command

Syntax SHOW COLSEP Considerations In the Neoview Script interface, you must enter the command on one line. The command doesnot require an SQL terminator. Examples • This SHOW COLSEP command displays the column separator. SQL> show colsepCOLSEP " " SQL> set colsep * SQL> show colsepC...

Page 115 - SHOW LIST_COUNT Command; SHOW MARKUP Command

Examples • This command shows that the idle timeout value of the session is 30 minutes, which is thedefault: SQL>show idletimeoutIDLETIMEOUT 30 min(s) • This command shows that the idle timeout value of the session is four hours: SQL>show idletimeoutIDLETIMEOUT 240 min(s) • This command shows ...

Page 116 - This command displays the value set for the markup option:; SHOW MODE Command; This command shows that the mode of the current session is CS:; SHOW MVGROUPS Command; matches an uppercase string unless you

Examples This command displays the value set for the markup option: SQL>show markupMARKUP RAW SHOW MODE Command The SHOW MODE command displays the operating mode of the current Neoview Script session.The default is SQL. Syntax SHOW MODE Considerations In the Neoview Script interface, you must ent...

Page 117 - matches an uppercase string unless you enclose it within double

Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • If you do not specify a wild-card pattern in a SHOW MVGROUPS command, NeoviewScript displays all the materialized view groups that exist in the current schema. •...

Page 118 - combined with these wild-card characters:; SHOW PARAM Command

quotes. To look for similar values, specify only part of the charactersof wild-card-pattern combined with these wild-card characters: Use a percent sign to indicate zero ormore characters of any type. For example, %art% matches SMART , ARTIFICIAL , and PARTICULAR but not smart or Hearts . "%art%...

Page 120 - SHOW SCHEMA Command; SHOW SCHEMAS Command

Examples • This SHOW PREPARED command shows all the prepared statements, by default: SQL>show preparedS1 select * from t1 S2 select * from student T1 select * from test123 SQL> show prepared s% S1 select * from t1 S2 select * from student SQL> show prepared t% T1 select * from test123 SHOW ...

Page 122 - SHOW SESSION Command; SHOW SESSION or SESSION displays these attributes:

SHOW SESSION Command SHOW SESSION or SESSION displays attributes of the current Neoview Script session. You canalso use the ENV command to perform the same function. Syntax [SHOW] SESSION Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not re...

Page 123 - SHOW SQLPROMPT Command

Current setting (on or off) of the elapsed time. By default, the elapsed time is off.For more information, see “Displaying the Elapsed Time” (page 54) and “SET TIMING Command” (page 113) . TIMING User name that you entered when logging in to the database platform. For moreinformation, see “Logging I...

Page 124 - SHOW SQLTERMINATOR Command; SHOW SYNONYMS Command

Considerations • In the Neoview Script interface, you must enter the command on one line. The commanddoes not require an SQL terminator. • You can execute this command only in SQL mode. Example This command shows that the SQL prompt for the current session is SQL> : SQL>show sqlpromptSQLPROMPT...

Page 125 - This command shows all the synonyms in the current schema, SALES:; SHOW TABLE Command

look for similar values, specify only part of the characters of wild-card-pattern combined with these wild-card characters: Use a percent sign to indicate zero ormore characters of any type. For example, %art% matches SMART , ARTIFICIAL , and PARTICULAR but not smart or Hearts . "%art%" matc...

Page 128 - This command shows all the tables in the current schema, PERSNL:; SHOW TIME Command

wild-card-pattern is a character string used to search for and display tables with namesthat match the character string. wild-card-pattern matches an uppercase string unless you enclose it within double quotes. To lookfor similar values, specify only part of the characters of wild-card-pattern combi...

Page 129 - This command shows that the setting for the elapsed time is OFF:; SHOW VIEWS Command; matches an

Syntax SHOW TIME Considerations In the Neoview Script interface, you must enter the command on one line. The command doesnot require an SQL terminator. Example This command shows that the setting for the local time in the SQL prompt is OFF: SQL>show timeTIME OFF SHOW TIMING Command The SHOW TIMIN...

Page 130 - SPOOL Command

for similar values, specify only part of the characters of wild-card-pattern combined with these wild-card characters: Use a percent sign to indicate zero ormore characters of any type. For example, %art% matches SMART , ARTIFICIAL , and PARTICULAR but not smart or Hearts . "%art%" matches s...

Page 131 - VERSION Command

ON starts the logging process and records information in the sqlspool.lst file in the Neoview Script bin directory. ON CLEAR instructs Neoview Script to clear the contents of the sqlspool.lst file before logging new information to the file. log-file is the name of a log file into which Neoview Scrip...

Page 133 - B Supported SQL Statements

B Supported SQL Statements Neoview Script supports these SQL statements, SQL utilities, and other SQL-related commands.For more information about these statements, see the Neoview SQL Reference Manual. For a list ofstatements that are available only to HP support, see the Neoview Database Support Gu...

Page 135 - C Connectivity Service Commands; Any user can execute the; INFO DS Command; None of the servers or the EVARs are shown in this display.; This command displays information about the data source

C Connectivity Service Commands Neoview Script supports connectivity service commands in the Neoview Script interface inconnectivity service (CS) mode. You can execute connectivity service commands interactivelyor in script files that you run in CS mode. For information about changing to CS mode, se...

Page 137 - Index; Symbols

Index Symbols -DhpnvsLF property, 35-dsn parameter, 46-h parameter, 46-host parameter, 46-no connect parameter, 47-noconnect examples of, 50 -p parameter, 46-password parameter, 46-q parameter description of, 47examples of, 48 -s parameter description of, 47examples of, 49 -script parameter, 47-sql ...