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