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

Index
Symbols
-DhpnciLF property, 42
-dsn parameter, 56
-h parameter, 56
-help, 57
examples of, 60
-host parameter, 56
-noconnect
examples of, 59
-noconnect parameter, 56
-p parameter, 56
-password parameter, 56
-q parameter
description of, 56
examples of, 57, 58
-s parameter
description of, 56
examples of, 59
-script parameter, 56
-sql parameter, 56
-u parameter, 56
-user parameter, 56
-version, 57
examples of, 60
/ command
example of, 69
syntax of, 92
@ command
example of, 78
syntax of, 92
_JAVA_OPTIONS environment variable
setting at a command-line prompt, 44
setting in the user profile, 46
setting in Windows System Properties, 44
A
Admin_Load_DataSource, 54
ALLOW command, syntax of, 93
B
bin directory, 41
C
Case sensitivity, 62
CLEAR command, syntax of, 93
CLEAR option, 74
Command line, breaking, 61
Comments, 77
Conditional exit, 98, 113
CONNECT command, syntax of, 93
Continuation prompt, 61
CREATE SCHEMA statement
description of, 155
example of, 57, 78
CREATE TABLE statement
description of, 155
example of, 78
CREATE TRIGGER statement
example of, 73
CS mode, 106
D
Data definition language (DDL) statements, running
simultaneously, 79
Data source connection, 61
Database, creating, 79
Default schema, 65
DENY command, syntax of, 94
DISCONNECT command, 95
Documents, related information, 18
Download site, 27
E
Editing commands, FC, 99
Elapsed time, displaying, 64
Enable trace
setting the Java option property, 46
ENV command, syntax of, 95
Environment variables
_JAVA_OPTIONS, 42, 44
HPNCI_DATASOURCE, 81
HPNCI_PASSWORD, 81
HPNCI_SERVER, 81
HPNCI_USER, 81
PATH, 24, 52
Error messages, 69, 75
EXECUTE statement
description of, 156
examples of, 72
EXIT command, 97
EXPLAIN statement
description of, 156
F
FC command, 98
G
GET STATISTICS command, 101
H
HELP command, syntax of, 102
HISTORY command, 102
Host name, 53
hpnci directory, 41
hpnci.bat, creating a shortcut to, 49
hpnci.cmd, location of, 41
hpnci.jar, location of, 41
hpnci.pl
description of, 84
location of, 41
hpnci.py
161