Owner manual

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.