Hp Integrity NonStop J-Series Manual do Utilizador Página 54
- Página / 110
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
2. In the right pane, click Columns.
The following details appear:
• Primary Key — An icon or special symbol to indicate that the column is part of the primary
key. If the column is not a part of the primary key, the field is blank.
• Column Name — The name of the column (string).
• Data Type: — The SQL data type of the column.
• Nullable: — If a column is NOT NULL or NOT NULLABLE NOT DROPPABLE, the value
displayed is Not Nullable Not Droppable. Otherwise, the field is blank.
• Default: — A constant selected by default if no value was specified for this column.
• Heading: — The string displayed at the top of the column values when a select statement
is executed on the table.
Viewing table primary key properties
To view the primary key properties:
1. In the navigation tree, select the table.
2. In the right pane, click Primary Key.
The following details appear:
• Constraint Name: — The name of the constraint when the table was created. For more
information, see the HP NonStop SQL/MX Release 3.2 Reference Manual.
• Metadata UID: — The internal UID number for the constraint.
• Droppable: — This property indicates whether this constraint can be dropped. You can
specify whether the constraint can be dropped while creating the table.
• Position: — The position of the column in the primary key order.
• Column Name: — The name of the column (string).
• Data Type: — The SQL data type of the column.
• Sort Order: — The order specified as Ascending or Descending.
• Added By: — This property indicates whether the column was added by the system or
by the user.
Viewing hash key properties
To view the hash key properties:
1. In the navigation tree, select the table.
2. In the right pane, click Hash Key.
The following details appear:
• Key sequence: — The position of the column in the hash key order.
• Column Name: — The name of the column (string).
• Sort Order: — The order specified as Ascending or Descending.
Viewing store order properties
You can specify the store order properties while creating a table. Alternatively, the store order
properties can be determined by the system. For more information, see the HP NonStop SQL/MX
Release 3.2 Reference Manual. To view the store order properties:
1. In the navigation tree, select the table.
54 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
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.027 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais