Hp Integrity NonStop J-Series Uživatelský manuál Strana 5
- Strana / 110
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
Viewing the table index columns.....................................................................................59
Viewing the table index attributes....................................................................................59
Viewing the DDL output for a table index..........................................................................60
Viewing information related to table index partitions..........................................................60
Displaying table triggers and their properties.........................................................................61
Viewing the table trigger attributes..................................................................................62
Viewing information on related objects.............................................................................62
Viewing the DDL output for a table trigger........................................................................63
Managing objects using the SHOW DDL option.........................................................................63
Viewing schema views and their properties................................................................................64
Viewing properties related to view columns...........................................................................65
Viewing attributes of a view................................................................................................66
Viewing information on related objects.................................................................................66
Viewing DDL information of a table......................................................................................66
Viewing information related to view privileges........................................................................67
Viewing procedures and their properties....................................................................................67
Viewing attributes of a procedure.........................................................................................68
Viewing parameters of a procedure......................................................................................69
Viewing information on related objects.................................................................................70
Viewing DDL information of a procedure...............................................................................70
Viewing information related to procedure privileges................................................................70
Viewing SQL/MP aliases and their properties.............................................................................71
Viewing attributes of the SQL/MP alias.................................................................................72
Viewing DDL information of a SQL/MP alias.........................................................................72
Viewing table statistics and their properties................................................................................72
7 Managing MXCS objects..........................................................................76
Viewing MXCS servers............................................................................................................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
Adding and modifying the resource management policy.........................................................85
Using the DEFINEs and SETs tab..........................................................................................85
Using the Control Query Defaults tab...................................................................................87
Using the Control Table Statements tab.................................................................................87
If-Locked.......................................................................................................................88
MDAM........................................................................................................................88
Priority.........................................................................................................................88
Similarity check............................................................................................................89
Table Lock....................................................................................................................89
Timeout........................................................................................................................89
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
Starting and stopping server traces...........................................................................................91
Viewing MXCS user permissions...............................................................................................92
Adding an MXCS user............................................................................................................93
Editing MXCS user permissions.................................................................................................94
Deleting an MXCS user...........................................................................................................94
Contents 5
- 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
Související produkty a manuály pro Počítačový hardware Hp Integrity NonStop J-Series
(110 stránky)
(82 stránky)© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.052 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce