Hp Integrity NonStop J-Series Manual do Utilizador Página 61
- Página / 110
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
2. In the right pane, click Partitions.
The following details related to table index partitions appear:
• Partition Number: — The name of the column (string).
• System: — This attribute specifies the sort order as Ascending or Descending.
• Name: — This attribute specifies whether the column was added by the system or a user.
• File: — The physical file where the partition is located.
• Percent allocated: — The percentage of the partition used.
• Row count: — The number of rows in the partition.
• Rows Inserted Since Last Update Stats: — The number of rows inserted after the Update
Statistics command was last run.
• Rows Deleted Since Last Update Stats: — The number of rows deleted after the Update
Statistics command was last run.
• Rows Updated Since Last Update Stats: — The number of rows updated after the Update
Statistics command was last run.
• Primary Extents: — The size of the primary extent in pages.
• Secondary Extents: — The size of the secondary extents in pages.
• Max Extents: — The maximum number of extents.
• Allocated Extents: — The number of extents allocated.
• Max Size: — The maximum size of the partition.
• Current EOF: — The space used in the partition.
Displaying table triggers and their properties
A trigger is a mechanism that resides in the database and specifies that when a particular action—an
insert, delete, or update occurs on a table, SQL/MX should automatically perform one or more
additional actions.
To view the table triggers:
1. Log on to the HP NonStop SQL/MX Database Manager.
2. Under the navigation tree pane, click Database.
MXDM displays a list of existing systems.
3. In the navigation tree, expand the contents of the system .
The list of catalogs appears.
4. Expand the contents of a catalog.
The list of schemas appears.
5. Expand the contents of a schema.
The Tables folder appears.
6. Expand the contents of a table.
The Indexes and Triggers folders appear.
Viewing table properties 61
- 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
Manuais e produtos relacionados com Hardware de computador Hp Integrity NonStop J-Series
(110 páginas)
Hardware de computador Hp Blade de servidor HP ProLiant BL685c G6 Manual do Utilizador
(117 páginas)
(117 páginas)
Hardware de computador Hp Blade de servidor HP ProLiant BL490c G7 Manual do Utilizador
(112 páginas)
(112 páginas)
© 2020, manymanuals-pt.com. Todos os direitos reservados. | 0.038 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais