beautypg.com

Chapter 8, Chapter 8. managing data, Querying data – HP NonStop G-Series User Manual

Page 88

background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005

8-1

CHAPTER 8.

MANAGING DATA

Using dba/m Database Manager, you can

Query a database

Copy data to or from Enscribe files and SQL tables, appending the
data to the files or tables

Load data in an existing database, overwriting the existing data

Display the contents of a file

You can perform these functions by accessing windows from the Data
button in the Main window. The menu hierarchy is shown in Figure 10-1.

Figure 8-1. Diagram of Data Management Menus.

Querying Data

Using the Query Data window, you can execute simple queries on tables
and views. You can also insert, update, and delete data. You must be
authorized to perform the query, add, change, or delete operations.

When you display the Query Data window, the window is automatically
placed in select mode so that you can create a query. After you have
queried a database, you can change the mode to Add, Delete, or Update
mode by clicking on the appropriate button in the Mode pane at the bottom
of the window.