beautypg.com

1 introduction to the hp database manager, Hp database manager – HP Neoview Release 2.4 Software User Manual

Page 9

background image

1 Introduction to the HP Database Manager

HP Database Manager

The HP Database Manager (HPDM) is an integrated graphical client that allows you to connect
and manage multiple HP Neoview platforms. HPDM provides database-object browsing
capabilities that are superior to the current Neoview DB Admin product.

HP Database Manager requires the HP ODBC 2.0 client driver for Windows to connect to an HP
Neoview platform. Download the HP ODBC 2.0 client driver from the HP software download
site and install it prior to running the HP Database Manager.

NOTE:

HP recommends using the HP Database Manager product, although you can currently

still use the DB Admin product.

The HP Database Manager (HPDM) features are:

Database-Object Browsing
— Provides database object browsing capabilities (these capabilities also exist in the DB

Admin product)

— Displays partition information for individual Neoview SQL objects
— Displays a partition summary for groups of objects (for example, all tables in a schema)
— Displays schema size
— Displays sequence numbers in table columns
— Provides a DDL tool to generate and save the DDL script for a group of Neoview SQL

objects

— Displays table profile and statistics information
— Generates and displays system status messages

SQL Whiteboard
— Executes DDL/DML statements
— Persists queries across sessions for reuse
— Exports query results to a spreadsheet
— Allows a portion of an SQL statement to be highlighted and executed (syntax

highlighting)

— Cancels an executing query
— Opens/saves query text to a file

HPDM Framework
— Provides connection management for widgets
— Supports persistence for widget and application data
— Includes menu management
— Implements area management (hide, show, and deploy)
— Exports grid contents to a spreadsheet
— Manages options for an HPDM application as a whole and for individual areas and

widgets

— Launches the Neoview Command Interface (NCI)
— Supports character sets for ISO, SJIS, or Unicode based on a single-client locale (only

one character set can be configured for each install).

HP Database Manager

9