beautypg.com

4 perform basic hpdm operations, 5 manage database objects – HP Neoview Release 2.4 Software User Manual

Page 4

background image

Customize HPDM Windows................................................................................................................32
Manage Windows.................................................................................................................................32
Get Version and Build Information......................................................................................................32

4 Perform Basic HPDM Operations...............................................................................35

Sort and Move Data Columns...............................................................................................................35
Clone a Tab............................................................................................................................................36
Export Data...........................................................................................................................................37

Export Data to the Clipboard..........................................................................................................37
Export Data to a File........................................................................................................................37

Save Data in CSV Format...........................................................................................................37
Save Data in HTML Format.......................................................................................................37

Save Data to a Spreadsheet..............................................................................................................37
Export Data to a Browser.................................................................................................................37

Communicate System Messages to Users.............................................................................................38

Learn About the Monitoring Area...................................................................................................38
Use the System Message Tab...........................................................................................................38
Navigate the System Message Tab..................................................................................................39
Create a System Message.................................................................................................................39
Clone the System Message Tab........................................................................................................39

Save and Import System Definitions....................................................................................................39
View Event Messages............................................................................................................................40

View Dial Out and Database Events...............................................................................................40
See the Trace Event Message Format...............................................................................................41
Resource Statistics Event Message Format......................................................................................42
Session Statistics: Connection Information.....................................................................................42
Session Statistics: Session Summary Information...........................................................................43
Statement Statistics: SQL Statement................................................................................................44
Statement Statistics: SQLExecute.....................................................................................................44
Statement Statistics: SQLExecDirect................................................................................................45
Statement Statistics: SQLPrepare.....................................................................................................45
Statement Statistics: SQLFetch........................................................................................................46

5 Manage Database Objects........................................................................................47

Display Schemas and Their Objects......................................................................................................47

Attributes Tab..................................................................................................................................48
Tables Tab........................................................................................................................................48
Materialized Views Tab...................................................................................................................48
Materialized View Groups Tab........................................................................................................48
Views Tab.........................................................................................................................................49
Procedures Tab................................................................................................................................49
Synonyms Tab..................................................................................................................................49
DDL Tab...........................................................................................................................................49
Privileges Tab...................................................................................................................................50
Schema Size.....................................................................................................................................50

Display Tables and Their Properties.....................................................................................................50

Columns Tab....................................................................................................................................51
Primary Key Tab..............................................................................................................................52
Hash Key Tab...................................................................................................................................52
Unique Constraints Tab...................................................................................................................52
Foreign Keys Tab.............................................................................................................................52
Attributes Tab..................................................................................................................................53
Partitions Tab...................................................................................................................................53

4

Table of Contents