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

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>/
(EXPR)
--------------------
62
--- 1 row(s) selected.
SQL>
ALIAS Command
The ALIAS command allows you to map a string to any NCI or Neoview SQL command. The
syntax of the NCI or Neoview SQL command is checked only on execution of the mapped string.
This command replaces only the first token of a command string, which allows the rest of the
tokens to be treated as parameters.
Syntax
ALIAS value AS command SQL-terminator
value
is a case-insensitive string without spaces. Value cannot be an NCI command.
/ Command 89