Hp Neoview Release 2.5 Software Manuel d'utilisateur Page 213
- Page / 284
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
The buttons across the top of the Statement List pane allow you to select individual statements
or select all statements to be executed:
FunctionButton
Selects all statements in the Statement List.[ All ]
Deselects all statements in the Statement List.[ None ]
Removes selected statements (marked checked boxes) or the statement results, or both, depending on
the option you select in the dialog box.
NOTE: You cannot discard a statement or results while the statement is executing. If a currently
executing statement is part of a [ Discard ] selection, it will be skipped.
Use the [ Discard ] button when you want to free up virtual memory or when HPDM indicates that
system resources are running low. Until you exit the SQL Whiteboard, the result of every executed
statement is cached. If you already executed several large statements in the current session, the results
stay in memory, and less memory is available for newer executions. “Understand Page Mode” (page 214)
describes how the SQL Whiteboard caches and displays large result sets.
[ Discard ]
Learn About the Statement Pane
The Statement pane allows you to enter any SQL command (DDL or DML) in the text box. The
maximum number of characters you can enter in the text box is 2147483647. The maximum limit
is enforced by the .NET text box control.
In the Statement pane, these fields define a statement:
DescriptionField
Enter the name of the SQL statement. You can specify a name to uniquely identify the statement in
the statement list. Use [ Add ] to add the statement to the statement list. Use [ Update ] to update an
existing statement from the statement list.
Name
Select a system from the System drop-down box on which you want to execute the query.
System
Specifies the maximum rows that you want returned and displayed in the details. The default is 500
rows, and the maximum is 2147483647.
Max Rows
Select a schema name from the Schema drop-down box. If you do not explicitly qualify the query by
specifying a 3-part ANSI name, the default schema is the currently selected value in the drop-down
box.
Schema
Select the number of rows to be fetched and displayed in one page of the statement result set. You can
set the Rows/Pages value to between 1 and ≤ 100,000. Or use the default Rows/Pag e value (0), which
causes HPDM to try to fetch and display the entire result set.
If you specify a value of 1 or more for the Rows/Page, or if you use the default setting and HPDM
cannot fetch and cache (for display purposes) the entire result set using available memory, HPDM
automatically displays the result set in pages. For more information about page mode, see “Understand
Page Mode” (page 214).
Rows/Page
To execute the statement, click [ Execute ].
The buttons across the bottom of the Statement pane allow you to test the statement and change
it:
FunctionButton
Allows you to add a new SQL statement or duplicate a statement to the Statement List.[ Add ]
Allows you to update the statement. Make the required change, and then select [ Update ].[ Update ]
Causes the statement to be executed and shows the results in the Statement Details pane.[ Execute ]
Terms
Learn About the Statement Pane 213
- HP Part Number: 613120-001 1
- Published: July 2010 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
- Table of Contents 11 11
- About This Guide 13
- Intended Audience 14
- Related Documentation 15
- • Connectivity 16
- • Reference 16
- Resources on the Web 17
- Send Feedback to HP 17
- 1 About HPDM 19
- 20 About HPDM 20
- 2 Install and Start HPDM 23
- Exit the HP Database Manager 24
- 3 Connect and Disconnect 25
- Password Considerations 27
- Disconnect From a System 27
- Log On and Off 28
- Use the Systems Tool 28
- Add a System 29
- Use the Add System Dialog Box 30
- Edit a System 32
- Add a System Like 33
- Remove a System 33
- Test a System 33
- Set the Connection Timeout 34
- 4 Navigate HPDM 35
- Use the Navigation Tree Pane 37
- Use the Right Pane 39
- Use the My Favorites Pane 40
- See the HPDM Banner 41
- Use Menu Bar Commands 42
- Use the Tools Menu Options 43
- Use the Windows Menu Options 43
- Use the Help Menu Options 43
- Use the HPDM Toolbar 44
- Manage Multiple Open Windows 45
- Clone Tabs 46
- Expand and Collapse Panes 46
- Sort and Move Data Columns 47
- Work With Data Grids 48
- Work With Data Grids 49 49
- Copy Data-Grid Information 50
- Work With Data Grids 51 51
- Customize the Data Grid 52
- Search the Data Grid 52
- Export Data 53
- Use the System Message Tab 54
- Create a System Message 54
- Clone the System Message Tab 55
- View Event Messages 56
- 6 Display Database Objects 63
- Attributes Tab 64
- Tables Tab 64
- Materialized Views Tab 64
- Materialized View Groups Tab 64
- Views Tab 65
- Procedures Tab 65
- Synonyms Tab 65
- Privileges Tab 66
- Schema Size 66
- Columns Tab 67
- Primary Key Tab 68
- Hash Key Tab 68
- Unique Constraints Tab 68
- Foreign Keys Tab 69
- Partitions Tab 69
- Usage Tab 69
- Statistics Tab 70
- Tables Summary 71
- Table Indexes Summary 73
- 76 Display Database Objects 76
- Materialized Views Summary 80
- Members Tab 84
- Parameters Tab 86
- Show DDL 92
- Viewing Sampled Statistics 94
- 7 Manage Roles 95
- 96 Manage Roles 96
- Add a Role 97
- Delete a Role 98
- Grant a Role to a User 98
- Use the Grant Role Dialog Box 99
- Revoke a Role From a User 99
- 8 Manage Users and Passwords 103
- Add a Database User 104
- Related Topics 105
- Add Multiple Database Users 106
- Copy a Database User 107
- Use the Edit User Dialog Box 109
- Platform Users 111
- Add a Platform User 112
- Copy a Platform User 112
- Edit a Platform User 114
- Passwords for Users 115
- 9 Manage Security Policies 117
- 118 Manage Security Policies 118
- 10 Manage Certificates 125
- Use the Generate CSR Tab 128
- 11 Manage Directory Servers 131
- • LDAP directory server 136
- Example: LDAP Server 137
- Edit a Directory Server 139
- Delete a Directory Server 140
- 12 Manage Data Sources 141
- Create a Data Source 142
- Use the DEFINEs and SETs Tab 147
- FunctionButton 148
- 148 Manage Data Sources 148
- Use the Controlled Tables Tab 149
- Copy a Data Source 150
- Start a Data Source 151
- Stop a Data Source 151
- Update a Data Source 152
- Delete a Data Source 152
- Delete a Data Source 153 153
- 13 Manage Connectivity 155
- Stop an NDCS Server 157
- Display NDCS Services 157
- Start an NDCS Service 158
- Stop an NDCS Service 159
- Start and Stop Server Traces 160
- Learn About Server Traces 160
- 14 Manage NDCS Privileges 161
- Revoke NDCS Privileges 162
- 15 Manage Procedures 163
- Download a JAR File 164
- Rename a JAR File 164
- Delete a JAR File 165
- Create a Procedure 165
- 166 Manage Procedures 166
- Use a Method in a Procedure 168
- Drop a Procedure 169
- 16 Use the System Monitor 171
- About the Timeline Tab 173
- About the Hybrid Tab 174
- 176 Use the System Monitor 176
- Change a Color Option 179
- 17 Respond to Alerts 181
- Understand Alerts 182
- Get Information About Alerts 183
- Control the Refresh of Alerts 187
- Update an Alert 189
- Update Multiple Alerts 190
- Make Notes About an Alert 190
- About the Console Tab 191
- About System Offender 193
- For example: 195
- Get Pstate Information 197
- DescriptionField or Option 198
- Query Information 202
- Compiler Statistics 203
- Runtime Statistics 205
- 19 Use the SQL Whiteboard 211
- 212 Use the SQL Whiteboard 212
- Understand Parameter Prompts 214
- Understand Page Mode 214
- Execute Highlighted Text 215
- Reuse a Connection 216
- Highlight SQL Syntax 217
- Manage the Layout of Panes 217
- 20 Use Metric Miner 219
- Launch Metric Miner 220
- See the Parts of Metric Miner 220
- Use the Metric Miner Toolbar 222
- Create Report Folders 224
- Run Statements 225
- Add Parameters to Statements 226
- Resolve Out-of-Memory Errors 228
- Export Metric Miner Data 228
- Run Statements 229 229
- Create and Manage Reports 230
- Configuration dialog box 231
- Modify a Saved Report 232
- Close a Report 233
- Delete a Report 233
- Copy a Report 233
- Import Neoview Reports 234
- Link and Drill Down 235
- Link and Drill Down 237 237
- Learn About NCI 239
- Locate the NCI Program 239
- Launch NCI 239
- Set Auto Logon Options 240
- 22 Manage Disk Space 241
- 242 Manage Disk Space 242
- 244 Manage Disk Space 244
- About the Monitoring Tab 246
- View the System Overall 248
- View the System Detail 249
- 250 Manage Disk Space 250
- View SQL Objects 252
- View the SQL Objects Detail 253
- 254 Manage Disk Space 254
- View Table Growth 257
- By Table Tab 258
- 260 Manage Disk Space 260
- About the Configuration Tab 261
- About the General Tab 262
- Space Reference Settings 263
- About the Advanced Tab 264
- Inventory Options 265
- Update Space Reference Tables 265
- System Registry Table Tab 266
- Glossary 267
- 268 Glossary 268
- 270 Glossary 270
- 272 Index 272
- 274 Index 274
- 276 Index 276
- 278 Index 278
- 280 Index 280
- 282 Index 282
Produits connexes et manuels pour Logiciel Hp Neoview Release 2.5 Software
(15 pages)
(37 pages)
(120 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.019 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels