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

SyntaxDescriptionCommand
See the “SHOW TIMING Command”
(page 150).
Displays the setting for the elapsed
time.
SHOW TIMING
See the “SHOW VIEWS Command”
(page 150).
Displays all or a set of the views that
exist in the current schema of the NCI
session.
SHOW VIEWS
See the “SPOOL Command”
(page 151).
Logs commands and output from NCI
to a log file.
SPOOL
See the “VERSION Command”
(page 154).
Displays the build versions of
Connectivity Services, Platform, Type
4 Driver, and NCI.
VERSION
@ 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 108).
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
The / command executes the previously executed SQL statement. This command does not repeat
an NCI command.
Syntax
/
Considerations
• 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.
SQL>/
92 NCI Commands