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

H
HELP command, 88
HISTORY command, 89
Host name, 35
HP_ prefix in schema names, 40
hpnci.bat, creating a shortcut to, 31
hpnci.pl, description of, 68
hpnci.py, description of, 68
hpnci.sh, setting the path of, 34
HPNCI_PERL_JSERVER environment variable, 65
HPNCI_PERL_JSERVER_PORT environment variable,
65
HPNCI_PYTHON_JSERVER environment variable, 65
I
Idle timeout value, 47
IF...THEN command, 90
Indexes, showing all indexes of a table, 50
INFO DS command, 153, 171
INFO EVAR command, 172
INFO RESOURCE command, 173
INFO USER command, 174
INSERT statement, example of, 48
Installation procedures, testing the launch of NCI, 29
Interface command (see Neoview Command Interface)
IP address, 35
L
LABEL command, 91
Launch parameters
descriptions of, 38
presetting on Linux or UNIX, 34
presetting on Windows, 32
LIST DS command, 175
LIST SERVICE command, 175
LOCALHOST command, 92
LOG command, 93
Log files
NCI session, 59
PRUN operation, 100
Logging in
default method, 35
using login parameters, 36
Logging output
concurrent sessions, 58
script file execution, 63
starting, 58
stopping, 59
viewing a log file, 59
Login environment variables
description of, 65
setting in the user profile, 68
setting in Windows System Properties, 66
setting on a Linux or UNIX command line, 68
setting on a Windows command line, 65
Login parameters
presetting on Linux or UNIX, 34
presetting on Windows, 32
specifying on the command line, 36
Look and feel
setting a look-and-feel type, 26
supported types, 25
M
Materialized views
showing all materialized views in a schema, 51
wild-card search, 132
MAXREORGSLICE, 107
MAXRUNTIME, 107
MODE command, 95
N
Neoview Command Interface, 42
breaking across lines, 45
case sensitivity, 46
description of, 23, 45
exiting, quitting, or disconnecting, 43
launching and running a command, 40
launching and running a script file, 41
launching from a Perl or Python command line, 68
launching on Linux or UNIX, 34
launching on Windows, 31
logging output, 58
Perl wrapper script, 68
product banner, 45
prompts, 45
Python wrapper script, 68
testing the launch of, 29
using in a script file, 61
Neoview SQL look and feel, 25
NS mode, 95
O
OBEY command, 62, 97
P
Parameters, SQL
displaying, 55
resetting, 55
setting, 55
PATH environment variable, 34
Perl command line, invoking NCI, 68
Perl program, running, 68
Perl wrapper script, description of, 68
Port number, default, 35
PREPARE statement, examples of, 54
Procedures, wild-card search, 135
Product banner, 45
Prompts
continuation, 45
standard, 45
PRUN command, 100
Python command line, invoking NCI, 68
Python program, running, 68
Python wrapper script, description of, 68
Q
QUIT command, 102
186 Index