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

/ 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)

--------------------

--- 1 row(s) selected.

SQL>/

(EXPR)

--------------------

--- 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

is an NCI command or Neoview SQL command.

SQL-terminator

is the default terminator (;) or a string value defined for the statement terminator by the “SET

SQLTERMINATOR Command” (page 122). For more information, see “Setting and Showing

the SQL Terminator” (page 48).

76 NCI Commands