HP NEOVIEW 544530-001 Manual de usuario Pagina 36
- Pagina / 142
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
execute in the Neoview Script interface. Each look-and-feel type accepts all the SQL statements,
commands, and syntax that Neoview Script currently supports.
Supported Look-and-Feel Types
Currently, Neoview Script supports the SQLPlus and Teradata look-and-feel types, in addition
to the default look and feel, Neoview SQL. The default look and feel, Neoview SQL, appears as
shown below:
Welcome to the HP Neoview Script Interface 2.1
(c) Copyright 2006, 2007 Hewlett-Packard Development Company, LP.
Connected to DataSource: TDM_Default_DataSource
SQL>create view persnl.salarylist
+>as select salary from persnl.employee;
--- SQL operation complete.
SQL>
The -DhpnvsLF property value for setting the SQLPlus look and feel is SQLPlus. The SQLPlus
look and feel appears as shown below:
Picked up _JAVA_OPTIONS: -DhpnvsLF=SQLPlus
Welcome to the HP Neoview Script Interface 2.1
(c) Copyright 2006, 2007 Hewlett-Packard Development Company, LP.
Connected to DataSource: TDM_Default_DataSource
SQL>create view persnl.salarylist
+>as select salary from persnl.employee;
View created.
SQL>
NOTE: The look and feel property value Oracle is supported for backward compatibility.
The -DhpnvsLF property value for setting the Teradata look and feel is BTEQ. Setting this
property results in a Teradata personality for the messages logged for all SQL operations within
Neoview Script. The Teradata look and feel appears as shown below:
SQL>set schema sch;
*** Schema has been set.
*** Total elapsed time was 16 second(s).
SQL>select * from book;
BOOKID BOOKTITLE BOOKAUTHORID ISCHECKEDOUT
----------- ------------------------------ ------------ ------------
13333 UML Simplified 93333 0
11111 C++ Internals 91111 0
12222 Object Oriented Design 92222 0
*** Query completed. 3 rows found. 4 columns returned.
*** Total elapsed time was 1 second(s).
SQL>
To set the look and feel, see:
• “Setting the Look and Feel at a Command-Line Prompt” (page 37)
• “Setting the Look and Feel in the System Properties on Windows” (page 37)
• “Setting the Look and Feel in the User Profile on Linux or UNIX” (page 39)
36 Installing Neoview Script
- 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
Relacionado con productos y manuales para Software HP NEOVIEW 544530-001
Software HP 700wl Manual de usuario
(388 paginas)
(388 paginas)
Software HP X9300 Guía de instalación
(151 paginas)
(151 paginas)
Software HP SP1 Manual de usuario
(143 paginas)
(143 paginas)
Software HP Q.11. (2510-24) Manual de usuario
(294 paginas)
(294 paginas)
Software HP 441877-00F Manual de usuario
(67 paginas)
(67 paginas)
Software HP 2000s Guía de usuario
(200 paginas)
(200 paginas)
Software HP 2012i Manual de usuario
(86 paginas)
(86 paginas)
Software HP XP12000 Manual de usuario
(38 paginas)
(38 paginas)
Software HP Moonshot-180G Guía de usuario
(719 paginas)
(719 paginas)
Software HP Transcend Traffix Manager Manual de usuario
(186 paginas)
(186 paginas)
Software HP 377707-002 Manual de usuario
(92 paginas)
(92 paginas)
Software HP 1TB Manual de usuario
(80 paginas)
(80 paginas)
Software HP M401dne Manual de usuario
(160 paginas)
(160 paginas)
Software HP 441877-00B Manual de usuario
(176 paginas)
(176 paginas)
Software HP 200 Manual de usuario
(676 paginas)
(676 paginas)
Software HP PROCURVE W.14.03 Manual de usuario
(594 paginas)
(594 paginas)
Software HP T8671-91017 Manual de usuario
(54 paginas)
(54 paginas)
Ironman Fitness 350r manuals
Owner’s manuals and user’s guides for Fitness, gymnastics & weight training Ironman Fitness 350r.
We providing 1 pdf manuals Ironman Fitness 350r for download free by document types: User Manual
Comentarios a estos manuales