Filter
Top Products
Index
Symbols
-DhpnvsLF property, 35
-dsn parameter, 46
-h parameter, 46
-host parameter, 46
-no connect parameter, 47
-noconnect
examples of, 50
-p parameter, 46
-password parameter, 46
-q parameter
description of, 47
examples of, 48
-s parameter
description of, 47
examples of, 49
-script parameter, 47
-sql parameter, 47
-u parameter, 46
-user parameter, 46
/ command
example of, 59
syntax of, 82
@ command
example of, 68
syntax of, 81
_JAVA_OPTIONS environment variable
setting at a command-line prompt, 37
setting in the user profile, 39
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