Index
Symbols
examples of, 50
description of, 47 examples of, 48
/command example of, 59
syntax of, 82
@command example of, 68 syntax of, 81
_JAVA_OPTIONS environment variable setting at a
setting in Windows System Properties, 37
A
Admin_Load_DataSource, 46
B
bin directory, 34
C
Case sensitivity, 52
CLEAR command, syntax of, 83 CLEAR option, 64 Command line, breaking, 51 Comments, 67
Conditional exit, 87, 97
CONNECT command, syntax of, 83 Continuation prompt, 51 CREATE SCHEMA statement
description of, 133 example of, 48, 68
CREATE TABLE statement description of, 133 example of, 68
CS mode, 92
D
Data definition language (DDL) statements, running simultaneously, 70
Data source connection, 51 Database platform, logging in to, 45 Database, creating, 70
Default schema, 55 DISCONNECT command, 84 Documents, related information, 17 Download site, 28
E
Editing commands, FC, 88 Elapsed time, displaying, 54 ENV command, syntax of, 85 Environment variables
_JAVA_OPTIONS, 35, 37 HPNVS_DATASOURCE, 71 HPNVS_PASSWORD, 71 HPNVS_SERVER, 71 HPNVS_USER, 71 PATH, 24, 44
Error messages, 59, 65 EXECUTE statement description of, 133 examples of, 62
EXIT command, 86
F
FC command, 87
H
HELP command, syntax of, 90 HISTORY command, 90 Host name, 45
hpnvs.bat, creating a shortcut to, 41 hpnvs.cmd, location of, 34 hpnvs.jar, location of, 34 hpnvs.pl
description of, 74 location of, 34
hpnvs.py description of, 74 location of, 34
hpnvs.sh location of, 34 setting the path of, 44
HPNVS_DATASOURCE environment variable, 71 HPNVS_PASSWORD environment variable, 71 HPNVS_SERVER environment variable, 71 HPNVS_USER environment variable, 71
I
Idle timeout value, 53
Indexes, showing all indexes of a table, 56
137