HP (Hewlett-Packard) 544530-001 Computer Accessories User Manual


 
script-file
is the name of an ASCII text file that contains SQL statements, Neoview
Script interface commands, and comments. If the script file exists outside
the local directory where you launch Neoview Script (by default, the
Neoview Script bin directory), specify the full directory path of the script
file.
(section-name) is the name of a section within the script-file to execute. If you specify
section-name, the @ command executes the commands between the
header line for the specified section and the header line for the next section
(or the end of the script file). If you omit section-name, the @ command
executes the entire script file. For more information, see “Section Headers”
(page 67).
Considerations
In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
Space is disallowed between the @ sign 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 time using the @ command. To run multiple script
files in parallel, see “Running Scripts in Parallel” (page 69).
Examples
This @ command runs the script file from the local directory (the same directory where you
are running Neoview Script):
SQL>@ddl.sql
This @ command runs the script file in the specified directory on a Windows workstation:
SQL>@c:\my_files\ddl.sql
This @ command runs the script file in the specified directory on a Linux or UNIX
workstation:
SQL>@./my_files/ddl.sql
/ Command
The / command executes the previously executed SQL statement. This command does not repeat
a Neoview Script interface command.
Syntax
/
Considerations
In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
You can execute this command only in SQL mode.
Example
This / command executes the previously executed SELECT statement:
SQL>select count(*) from persnl.employee;
(EXPR)
--------------------
62
--- 1 row(s) selected.
82 Neoview Script Interface Commands