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

number
is the number of commands to display. The default number is 10. The maximum number is
100.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can use the FC command to edit and re-execute a command in the history buffer, or
use the REPEAT command to re-execute a command without modifying it. See the “FC
Command” (page 98) or the “REPEAT Command” (page 114).
Example
Display the three most recent commands and use FC to redisplay one:
SQL>history 3
14> set schema sales;
15> show tables
16> show views
SQL>fc 14
SQL>set schema sales
....
Now you can use the edit capabilities of FC to modify and execute a different SET SCHEMA
statement.
LOCALHOST Command
The LOCALHOST command allows you to execute client machine commands.
Syntax
LOCALHOST | LH <client m/c commands>
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• The LOCALHOST command has a limitation. When input is entered for the operating system
commands (for example, date, time, and cmd), the input is not visible until you hit the enter
key.
• The LOCAL HOST command is supported in all modes.
• If the SET TIMING is set to ON, the elapsed time information is displayed.
Examples
• If you are using a Windows system, dir lists the contents of the directory name. Similarly,
if you are on a Unix system you enter LOCALHOST LS to display the contents of the folder.
SQL>LOCALHOST dir
Volume in drive C is E-Client
Volume Serial Number is DC4F-5B3B
Directory of c:\Neoview Command Interface\bin
07/11/2007 01:17 PM <DIR>
07/11/2007 01:17 PM <DIR>
07/16/2007 09:47 AM 1,042 hpnci-perl.pl
07/16/2007 09:47 AM 1,017 hpnci-python.pl
07/16/2007 09:47 AM 752 hpnci.cmd
07/16/2007 09:47 AM 1,416 hpnci.pl
07/16/2007 09:47 AM 2,388 hpnci.py
07/16/2007 09:47 AM 3,003 hpnci.sh
6 Files(s) 19,491 bytes
LOCALHOST Command 103