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......................................................................................................33

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

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

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

Save Data in CSV Format...........................................................................................................36
Save Data in HTML Format.......................................................................................................36

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

Communicate System Messages to Users.............................................................................................37

Learn About the Monitoring Area...................................................................................................37
Use the System Message Tab...........................................................................................................37
Navigate the System Message Tab..................................................................................................38
Create a System Message.................................................................................................................38
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...............................................................................................40
Resource Statistics Event Message Format......................................................................................41
Session Statistics: Connection Information.....................................................................................42
Session Statistics: Session Summary Information...........................................................................42
Statement Statistics: SQL Statement................................................................................................43
Statement Statistics: SQLExecute.....................................................................................................43
Statement Statistics: SQLExecDirect................................................................................................44
Statement Statistics: SQLPrepare.....................................................................................................45
Statement Statistics: SQLFetch........................................................................................................45

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