HP Integrity NonStop J-Series - Manual (Page 4)

Using a favorite.................................................................................................................33
Viewing a list of favorites....................................................................................................33
Removing a favorite............................................................................................................34
Removing a favorites folder.................................................................................................34
Considerations..................................................................................................................34
Using the navigation tree.........................................................................................................34
Using the right pane...............................................................................................................36
Working with windows, tabs, and panes...................................................................................37
Cloning tabs and managing multiple open windows..............................................................37
Expanding and collapsing panes.........................................................................................37
5 Performing basic MXDM operations............................................................39
Obtaining version and build information....................................................................................39
Resolving errors and error messages..........................................................................................39
Sorting and moving data columns.............................................................................................40
Working with data grids..........................................................................................................41
Introduction to data grids....................................................................................................41
Obtaining row details for a data grid...................................................................................42
Copying data grid information.............................................................................................43
Customizing the data grid...................................................................................................43
Searching the data grid......................................................................................................44
Copying data.........................................................................................................................45
Copying data to the clipboard.............................................................................................45
Copying data to a file........................................................................................................45
Copying data to a spreadsheet............................................................................................45
Copying data to a browser.................................................................................................46
Saving and importing system definitions....................................................................................46
6 Viewing database objects..........................................................................48
Viewing catalogs and their objects............................................................................................48
Viewing catalog attributes...................................................................................................49
Viewing catalog registrations...............................................................................................49
Viewing schemas within a catalog.......................................................................................50
Viewing catalog DDL..........................................................................................................50
Viewing schemas....................................................................................................................50
Viewing schema attributes...................................................................................................51
Viewing tables within a schema...........................................................................................51
Viewing schema views........................................................................................................52
Viewing schema procedures................................................................................................52
Viewing SQL/MP aliases within a schema.............................................................................52
Viewing sequence generators within a schema......................................................................53
Viewing schema DDL..........................................................................................................53
Viewing table properties..........................................................................................................53
Viewing table column properties..........................................................................................54
Viewing table primary key properties....................................................................................55
Viewing hash key properties................................................................................................55
Viewing store order properties.............................................................................................55
Viewing check constraints...................................................................................................56
Viewing unique constraints..................................................................................................56
Viewing foreign key properties.............................................................................................56
Viewing table attributes......................................................................................................56
Viewing table partition properties........................................................................................57
Viewing information on related objects.................................................................................58
Viewing DDL information of a table......................................................................................58
Viewing information related to table statistics.........................................................................59
Viewing information related to table privileges.......................................................................59
4 Contents