Hp Integrity NonStop J-Series Manual de usuario Pagina 98
- Pagina / 110
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
A Using the SQL Whiteboard
This appendix discusses the following topics:
• “Introduction to the SQL Whiteboard” (page 98)
• “Viewing the SQL Whiteboard” (page 98)
• “SQL Whiteboard panes” (page 98)
• “Statement List pane” (page 99)
• “Statement pane” (page 100)
• “Statement Details pane” (page 102)
• “Reusing a connection ” (page 103)
• “Loading and saving SQL statements to a file” (page 103)
• “Highlighting the SQL syntax” (page 104)
• “Managing the layout of panes” (page 104)
Introduction to the SQL Whiteboard
The SQL Whiteboard enables you to enter and execute SQL statements using MXDM, and provides
execution information for each of the SQL statements.
The list of SQL statements of one MXDM session persists in other MXDM sessions. Currently, MXDM
supports only one instance of the SQL Whiteboard.
You can specify SQL statements with parameters by enclosing parameter names within a double
dollar sign ($$). When the statement is executed, the SQL Whiteboard obtains values for the
parameters in the statement. You can reuse recently used values for those parameters.
Related Topics
“Viewing the SQL Whiteboard” (page 98)
“Saving and importing system definitions” (page 45)
Viewing the SQL Whiteboard
To view the SQL Whiteboard, use one of the following methods:
• On the MXDM toolbar, click SQL Whiteboard ( ).
• Select Tools→SQL Whiteboard.
Related Topics
“SQL Whiteboard panes” (page 98)
“Using the MXDM toolbar” (page 29)
SQL Whiteboard panes
Table 28 (page 98) describes the panes in the SQL Whiteboard.
Table 28 SQL Whiteboard panes
DescriptionPane
Displays a list of the SQL statements that you added using the Statement pane.Statement List
Enables you to enter any DML or DDL statement, including SELECT, INSERT, UPDATE, DELETE,
CREATE, ALTER, GRANT, DROP, REVOKE, and so on.
Statement
Displays detailed information about the execution results.Statement Details
Figure 38 (page 99) shows the SQL Whiteboard.
98 Using the SQL Whiteboard
- 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
Relacionado con productos y manuales para Hardware De La Computadora Hp Integrity NonStop J-Series
(110 paginas)
Hardware De La Computadora Hp Blade de servidor HP ProLiant BL495c G5 Manual de usuario
(95 paginas)
(95 paginas)
Hardware De La Computadora Hp Blade de servidor HP ProLiant BL685c G6 Manual de usuario
(117 paginas)
(117 paginas)
Hardware De La Computadora Hp Blade de servidor HP ProLiant BL490c G7 Manual de usuario
(112 paginas)
(112 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.027 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales