Filter
Top Products
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 statement to create a schema when launching the
Neoview Script interface:
• On Windows, in the Command Prompt window, enter:
cd hpnvs-installation-directory\nvscript\bin
hpnvs.cmd -q "create schema persnl"
• On Linux or UNIX, in the terminal window, enter:
cd hpnvs-installation-directory/nvscript/bin
./hpnvs.sh -q "create schema persnl"
After you enter the SQL statement, the Neoview Script interface launches, prompts you to log
in by default (if you did not specify -h, -u, -p, and -dsn on the command line), runs the SQL
statement, and then returns to the command prompt:
Host Name/IP Address: sys0101.mylab.mycorp.net:18650
User Name: dba1
Password:
DataSource Name [Admin_Load_DataSource]:
--- SQL operation complete.
C:\install\nvscript\bin>_
Example of Running a Neoview Script Interface Command With -q or -sql
Use -q or -sql with the PRUN command to run multiple script files simultaneously from the
command line:
• On Windows, in the Command Prompt window, enter:
cd hpnvs-installation-directory\nvscript\bin
hpnvs.cmd -q "prun"
• On Linux or UNIX, in the terminal window, enter:
cd hpnvs-installation-directory/nvscript/bin
./hpnvs.sh -q "prun"
After you enter the Neoview Script interface command, the Neoview Script interface launches,
prompts you to log in by default (if you did not specify -h, -u, -p, and -dsn on the command
line), and runs the command. The parallel run (PRUN) operation prompts you to enter settings
and then executes the script files. At the end of the PRUN operation, the Neoview Script interface
returns to the command prompt. For more information about the PRUN operation, see “PRUN
Command” (page 95).
Running a Script File When Launching Neoview Script
To run a script file when launching Neoview Script, use the -s or -script command-line
parameter.
NOTE: You cannot specify this parameter at the same time as the -q or -sql parameter.
After you launch the Neoview Script interface with -s or -script, Neoview Script executes
the script file. The Neoview Script interface remains open until you enter the EXIT, QUIT, or
48 Launching the Neoview Script Interface