Hp Neoview Release 2.4 Software Manuel d'utilisateur Page 118
- Page / 160
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Learn About the Statement List Pane
The Statement List pane provides a list of SQL statements that you added in a current session
or earlier sessions of the SQL Whiteboard tool. The list of SQL statements is persisted between
HPDM sessions the same way that connection information and favorites are persisted.
From the Statement List pane, you can:
• View the name and statement that was previously added in the Statement pane. Optionally,
you can explicitly add a statement to the statement list without executing it, using [ Add ].
• Update an existing statement in the list using [ Update ] in the Statement .
• Sort the statements based on the statement name or statement text. If you want to discard
unwanted statements, select the check box and use [ Discard ]. You can check or uncheck
statements using [ All ] or [ None ].
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 ]
Discards selected statements (marked checked boxes).[ 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:
How to use . . .Field
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
From the System drop-down box, select a system on which you want to execute the query.System
Select a catalog name from the Catalog drop-down box. If you do not explicitly qualify the query by
specifying a 3-part ANSI name, the default catalog is the currently selected value in the drop-down
box.
Catalog
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
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
Use [ Execute ] to execute the statement.
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 ]
118 Use the SQL Whiteboard
- HP Part Number: 597527-001 1
- Published: March 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
- Learn About This Document 9
- Resources on the Web 11
- Send Feedback to HP 11
- Part Number: 597527-001 12
- 1 Install and Start HPDM 13
- Start the HP Database Manager 14
- Use Menu Bar Commands 15
- Exit the HP Database Manager 15
- 2 Connect and Disconnect 17
- Disconnect From a System 18
- Log On and Off 19
- Use the Systems Tool 19
- Add a System 20
- Use the Add System Dialog Box 21
- Edit a System 22
- Add a System Like 23
- Remove a System 23
- Test a System 23
- 3 Navigate HPDM 25
- Use the Navigation Tree Pane 27
- Understand My Other Systems 28
- Use the Right Pane 29
- Use the My Favorites Pane 30
- Create a Favorite 31
- Use a Favorite 31
- View a List of Favorites 31
- Add a Favorite to a Folder 31
- See the HPDM Header 32
- Customize HPDM Windows 32
- Manage Windows 32
- Sort and Move Data Columns 35
- Clone a Tab 36
- Export Data 36
- Save Data to a Spreadsheet 37
- Export Data to a Browser 37
- Use the System Message Tab 37
- Create a System Message 38
- Clone the System Message Tab 39
- View Event Messages 40
- 5 Manage Database Objects 47
- Attributes Tab 48
- Tables Tab 48
- Materialized Views Tab 48
- Materialized View Groups Tab 48
- Views Tab 49
- Procedures Tab 49
- Synonyms Tab 49
- Privileges Tab 50
- Schema Size 50
- Columns Tab 51
- Primary Key Tab 52
- Hash Key Tab 52
- Unique Constraints Tab 52
- Foreign Keys Tab 52
- Usage Tab 53
- Partitions Tab 53
- Statistics Tab 54
- Tables Summary 55
- Table Indexes Summary 57
- 60 Manage Database Objects 60
- Materialized Views Summary 63
- Members Tab 66
- Parameters Tab 69
- Show DDL 74
- Viewing Sampled Statistics 76
- 6 Use the System Monitor 77
- About the Timeline Tab 79
- About the Hybrid Tab 80
- 82 Use the System Monitor 82
- Change a Color Option 85
- 7 Respond to Alerts 87
- Understand Alerts 88
- Get Information About Alerts 89
- Control the Refresh of Alerts 93
- Update an Alert 95
- Update Multiple Alerts 96
- Make Notes About an Alert 96
- About the Console Tab 97
- About System Offender 99
- For example: 101
- Get Pstate Information 104
- 9 Work With Data Grids 113
- Copy Data-Grid Information 114
- Search the Data Grid 116
- Customize the Data Grid 116
- 10 Use the SQL Whiteboard 117
- Understand Parameter Prompts 119
- Execute Highlighted Text 119
- Reuse a Connection 120
- Highlight SQL Syntax 120
- Manage the Layout of Panes 120
- Related Topics 121
- Learn About NCI 123
- Locate the NCI Program 123
- Launch NCI 123
- Set Auto Logon Options 123
- 12 Manage Disk Space 125
- 126 Manage Disk Space 126
- About the Monitoring Tab 128
- View the System Overall 131
- View the System Detail 132
- View the System Detail 133 133
- View SQL Objects 135
- View the SQL Objects Detail 136
- View Table Growth 140
- By Table Tab 141
- DescriptionField or Option 143
- View Table Growth 143 143
- About the Configuration Tab 144
- About the General Tab 145
- Space Reference Settings 146
- About the Advanced Tab 147
- Inventory Options 148
- Update Space Reference Tables 148
- Glossary 151
- 152 Glossary 152
- 154 Index 154
- 156 Index 156
- 158 Index 158
Produits connexes et manuels pour Logiciel Hp Neoview Release 2.4 Software
(74 pages)
(58 pages)
(102 pages)
(259 pages)
(159 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.029 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels