Neoview Command Interface (NCI) Guide (R2.5)

@ Command
The @ command executes the SQL statements and NCI commands contained in a specified script
file. The @ command is executed the same as the OBEY command. For more information on
syntax and considerations, see the “OBEY Command” (page 97).
Syntax
@{script-file | wild-card-pattern} [(section-name)]
script-file
is the name of an ASCII text file that contains SQL statements, NCI commands, and comments.
If the script file exists outside the local directory where you launch NCI (by default, the NCI
bin directory), specify the full directory path of the script file.
wild-card-pattern
is a character string used to search for script files with names that match the character string.
wild-card-pattern matches a string, depending on the operating system for
case-sensitivity, unless you enclose it within double quotes. To look for similar values, specify
only part of the characters of wild-card-pattern combined with these wild-card characters:
Use an asterisk (*) to indicate zero or more characters of any type. For example, *art* matches SMART,
ARTIFICIAL, and PARTICULAR.
*
Use a question mark (?) to indicate any single character. For example, boo? matches BOOK and BOOT
but not BOO or BOOTS.
?
(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 62).
Considerations
• 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 script name.
• For additional considerations, see the “OBEY Command” (page 97).
Examples
• This @ command runs the script file from the local directory (the same directory where you
are running NCI):
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 75