Hp Integrity NonStop J-Series Bedienungsanleitung Seite 56
- Seite / 110
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
2. In the right pane, click Attributes.
The following details appear:
• Name — The name of the table.
• Metadata UID — The internal UID number of the table.
• Log Inserts Only: — A string value of True or False.
• Reorganize Enabled: — A string value of True or False.
• Update Statistics Enabled: — A string value of True or False.
• Last Updated Statistics: — A string value of Never or a timestamp in the yyyy-MM-dd
HH:mm:ss.FFFFFF format.
• Audit Compressed: — The property indicates whether the compressed audit-checkpoint
messages are generated for Disk Process 2 (DP2) files. It is expressed as True or False.
• Clear On Purge: — The property indicates the disk erasure when the file is dropped. It is
expressed as True or False.
• Block Size: — The length of a block.
• Maximum Size: — The maximum size, expressed in megabytes, to which a table can
grow. If the maximum size is 0, then the string Determined by system appears.
• Record Size: — The row size, expressed in bytes, in each logical record.
• Creation Time: — The time and date when a table was created. The time and date are
expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
• Redefinition Time: — The time and date when a table was last redefined. The time and
date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing table partition properties
To view the partition properties:
1. In the navigation tree, select the table.
56 Viewing database objects
- 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
Verwandte Produkte und Handbücher für Computerhardware Hp Integrity NonStop J-Series
(110 Seiten)
(82 Seiten)© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.047 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern