Hp Integrity NonStop J-Series Instrukcja Użytkownika Strona 54
- Strona / 110
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
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
Powiązane produkty i podręczniki dla Sprzęt komputerowy Hp Integrity NonStop J-Series
(110 strony)
(82 strony)Audio Authority Motherboards user manuals
The list of Audio Authority Motherboards products contains 1 user manuals for 1 models. All pdf user’s guides are available for download or viewing online.
Komentarze do niniejszej Instrukcji