HP NEOVIEW 544530-001 Manuale Utente Scaricare il pdf (Pagina 72)

set HPNVS_PASSWORD=password

set HPNVS_DATASOURCE=data-source-name

Setting Login Environment Variables in the System Properties

1. Right-click the My Computer icon on your desktop, and then select Properties:

2. In the System Properties dialog box, click the Advanced tab.

3. Click the Environment Variables button:

72 Running Neoview Script From Perl or Python

1 2 ... 67 68 69 70 71 72 73 74 75 76 77 ... 141 142

HP Neoview Script Guide 1
Table of Contents 3
4 Table of Contents 4
Table of Contents 5 5
6 Table of Contents 6
Table of Contents 7 7
8 Table of Contents 8
Table of Contents 9 9
List of Figures 11
List of Tables 13
About This Document 15
Notation Conventions 16
Related Documentation 17
Neoview Customer Library 18
Neoview Support Library 18
Publishing History 19
HP Encourages Your Comments 19
2 Installing Neoview Script 23
Verifying the Java Version 24
Preinstallation Procedures 25 25
Installing the JDBC Driver 26
Verifying the JDBC Driver 26
Installation Procedures 27
Running the Installer 28
Installation Procedures 29 29
30 Installing Neoview Script 30
Installation Procedures 31 31
32 Installing Neoview Script 32
Installation Procedures 33 33
Postinstallation Procedures 34
SQL>version 35
SQL> 35
Supported Look-and-Feel Types 36
-DhpnvsLF=look-and-feel-type 38
-DhpnvsLF=SQLPlus 38
. .profile 39
40 Installing Neoview Script 40
Setting the PATH of hpnvs.sh 44
Default Login 45
Login Parameters 46
./hpnvs.sh -noconnect 50
SQL>quit 50
Interface 51
Case Sensitivity 52
Displaying the Elapsed Time 54
Showing the Schemas 56
Showing the Views in a Schema 57
Displaying Executed Commands 58
Clearing the Interface Window 58
Obtaining Help 58
Running SQL Statements 59
Preparing an SQL Statement 60
Setting Parameters 61
Resetting the Parameters 61
Logging Output 63
Stopping the Logging Process 64
Logging Output 65 65
Creating a Script File 67
Running a Script File 68
Running Scripts in Parallel 69
>perl example.pl 78
>python example.py 78
@ Command 81
/ Command 82
CLEAR Command 83
CONNECT Command 83
DISCONNECT Command 84
ENV Command 85
EXIT Command 86
FC Command 87
FC Command 89 89
HELP Command 90
HISTORY Command 90
LOG Command 91
MODE Command 92
OBEY Command 93
PRUN Command 95
QUIT Command 97
RECONNECT Command 98
REPEAT Command 98
RESET PARAM Command 99
RUN Command 100
SAVEHIST Command 101
SET COLSEP Command 101
SET HISTOPT Command 102
SET IDLETIMEOUT Command 103
SET MARKUP Command 104
SET MARKUP Command 105 105
SET LIST_COUNT Command 106
SET PARAM Command 107
Considerations 108
Examples 108
SET PROMPT Command 109
SET SQLPROMPT Command 110
SET SQLTERMINATOR Command 112
SET TIME Command 112
SET TIMING Command 113
SHOW COLSEP Command 113
SHOW HISTOPT Command 114
SHOW IDLETIMEOUT Command 114
SHOW LIST_COUNT Command 115
SHOW MARKUP Command 115
SHOW MODE Command 116
SHOW MVGROUPS Command 116
SHOW MVS Command 117
SHOW PARAM Command 118
SHOW PREPARED Command 119
SHOW SCHEMA Command 120
SHOW SCHEMAS Command 120
SHOW SESSION Command 122
SHOW SQLPROMPT Command 123
SHOW SQLTERMINATOR Command 124
SHOW SYNONYMS Command 124
SHOW TABLE Command 125
SHOW TABLES Command 127
SHOW TIME Command 128
SHOW TIMING Command 129
SHOW VIEWS Command 129
SPOOL Command 130
VERSION Command 131
B Supported SQL Statements 133
INFO DS Command 135
138 Index 138
140 Index 140

Commenti su questo manuale

Nessun commento

HP NEOVIEW 544530-001 Manuale Utente Pagina 72

Commenti su questo manuale

Prodotti e manuali riguardandi Software HP NEOVIEW 544530-001