Hp Integrity NonStop J-Series Manuale Utente Pagina 103
- Pagina / 110
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
Table 32 Execution Results fields
FunctionField or button
Indicates when the statement was last evaluated.Last Evaluated
Indicates the time taken to execute the query.Query Execution Time
Displays the executed statement status. The status indicates whether the statement was
executed successfully or whether the statement was canceled.
Status
Displays the next set of execution results when the statement execution happens in the page
mode. For more information on the page mode, see “Page mode” (page 101).
Next Page
For DML statements such as INSERT, DELETE, and UPDATE, the results indicate how many rows
were affected if the execution is successful. For other SQL commands, the results appear in text
form.
For SELECT statements, you can use the Copy options to copy the results to a file, clipboard, or a
spreadsheet. The copy options are Data to Clipboard, Data to Browser, Data to Spreadsheet, and
Data to File. The data is preserved only while the SQL Whiteboard remains open. The data is
flushed when the SQL Whiteboard is closed. Also, when in the page mode, you can copy data
in the current page only.
Table 33 (page 103) describes the tabs.
Table 33 Statement Details tabs
FunctionTab
Displays the statement execution error.Execution Error
Displays values set for the current or earlier execution. The Execution Parameters tab
is displayed only if the statement has parameters.
Execution Parameters
Displays the statement that was executed with the parameters (if any), replaced with
their values.
Executed Statement
For more information on the page mode, see “Page mode” (page 101).
Related Topic
“Copying data” (page 44)
Term
page mode
Reusing a connection
The reuse connection feature is enabled by default in the SQL Whiteboard. As a result, all queries
executed for the selected system use the same connection. This system appears in the Statement
Pane, under System. To close the connection, right-click the system icon in the left pane and select
Disconnect. As a result, if the SQL Whiteboard is using the same connection, it stops. HP
recommends that you disconnect the system to release system resources.
Loading and saving SQL statements to a file
The SQL Whiteboard provides commands that enable you to import an SQL statement from a text
file to the Statement pane. You can also copy SQL statements from the Statement pane to a specified
text file.
Table 34 (page 104) describes the commands in the File menu that you can use to import and copy
SQL statements.
Reusing a connection 103
- Release 3.2 1
- Contents 3
- 4 Contents 4
- Contents 5 5
- 6 Contents 6
- About this guide 7
- Related documentation 8
- • Migration guides 9
- • Data management guides 9
- • Online help 9
- Notation Conventions 10
- HP encourages your comments 11
- 1 Introduction to MXDM 12
- MXDM functional flow 13
- 14 Introduction to MXDM 14
- Supported version of SQL/MX 15
- Prerequisites 15
- Installing MXDM 16
- Uninstalling MXDM 16
- Uninstalling MXDM 17 17
- Starting up MXDM 18
- Adding a system 18
- Connecting to a system 19
- Disconnecting from a system 21
- Using the Systems Tool 21
- Editing a system definition 23
- Copying a system definition 23
- Removing a system 24
- Testing a system definition 24
- Exiting MXDM 25
- 4 Navigating MXDM 26
- MXDM banner 27
- Using the MXDM menus 27
- Using the File menu options 28
- Using the Edit menu options 28
- Using the Tools menu options 28
- Using the MXDM toolbar 29
- Selecting an area 30
- Using the My Favorites pane 32
- Using the navigation tree 33
- Using the right pane 35
- Figure 9 Window controls 37
- Working with data grids 40
- Working with data grids 41 41
- Copying data grid information 42
- Customizing the data grid 42
- Searching the data grid 43
- Copying data 44
- Copying data to a browser 45
- 6 Viewing database objects 47
- Viewing catalog attributes 48
- Viewing catalog registrations 48
- Viewing schemas 49
- Viewing schema attributes 50
- Viewing schema views 51
- Viewing schema procedures 51
- Viewing table properties 52
- Viewing table properties 53 53
- Viewing hash key properties 54
- Viewing check constraints 55
- Viewing unique constraints 55
- Viewing table attributes 55
- 56 Viewing database objects 56
- Viewing table properties 57 57
- 58 Viewing database objects 58
- Viewing table properties 59 59
- 60 Viewing database objects 60
- Viewing table properties 61 61
- 62 Viewing database objects 62
- ◦ Delete 63
- ◦ Insert 63
- ◦ Select 63
- ◦ Update 63
- Viewing attributes of a view 66
- 68 Viewing database objects 68
- ◦ CONTAINS SQL 69
- ◦ MODIFIES SQL DATA 69
- ◦ READS SQL DATA 69
- 70 Viewing database objects 70
- 72 Viewing database objects 72
- 74 Viewing database objects 74
- 7 Managing MXCS objects 76
- Stopping an MXCS server 78
- Viewing MXCS Services 78
- Starting up an MXCS service 79
- Stopping an MXCS service 80
- Viewing data sources 81
- Creating a data source 82
- Using General Properties 83
- About DEFINEs 85
- About SETs 86
- Creating a data source 87 87
- If-Locked 88
- Priority 88
- Copying a data source 89
- Starting up a data source 90
- Stopping a data source 90
- Updating a data source 91
- Deleting a data source 91
- Viewing MXCS user permissions 92
- Adding an MXCS user 93
- Editing MXCS user permissions 94
- Deleting an MXCS user 94
- Deleting an MXCS user 95 95
- Interface 96
- Setting Auto Logon options 97
- A Using the SQL Whiteboard 98
- Statement List pane 99
- Statement pane 100
- Page mode 101
- Statement Details pane 102
- Reusing a connection 103
- Highlighting the SQL syntax 104
- Managing the layout of panes 104
- Glossary 105
- 106 Glossary 106
- 108 Index 108
- 110 Index 110
Prodotti e manuali riguardandi Hardware del computer Hp Integrity NonStop J-Series
(110 pagine)
(82 pagine)© 2020, manymanuals.it. Tutti i diritti riservati | 0.088 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale