HP 3000 Manuals HP 3000 Manuals
Summary of Commands to Display Information about the Database
DBChange Plus provides specific commands for displaying information about
the database. Table 3-1 alphabetically lists the commands used for
printing and reviewing database structure information and summarizes
their functions.
The DBCPLUS program provides two ways to display information about the
database structure, as follows:
* Printing the schema to obtain information about the entire
database structure.
* Using the various REVIEW commands to display information about
specific parts of the database. For example, if you only want
information about a specific data set, then use the REVIEW SET
command.
In both cases, all changes currently stored in the change file are
displayed. Because information stored in the change file is not
permanently applied until you run the DBAPLUS program, the PRINT SCHEMA
and REVIEW commands are useful when verifying structural changes before
you actually restructure the database or when viewing the original
database structure before making changes.
NOTE Before invoking any of the following commands, you must log on to
the system as the database creator, run the DBCPLUS program and
specify the database for which you want to display information.
Refer to chapter 1, "Introduction to DBChange Plus."
Unless redirected, output is printed to $STDLIST. Refer to "Redirecting
Input, Output, and the Schema" in chapter 1, "Introduction to DBChange
Plus."
Table 3-1. Summary of Commands to Display Information about the Database
-----------------------------------------------------------------------------------------------
| | | |
| Command | Keyword | Description |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| PRINT | SCHEMA | Prints the database schema. |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| REVIEW | BLOCKS | Displays information about the data sets in the |
| | | database. Includes data set type, field count, |
| | | path count, entry length, capacity, blocking |
| | | factor, and block length. |
| | | |
| | FIELDS | Displays information about the fields (data items) |
| | | of master and detail data sets. Includes search |
| | | items, sort items, and linked data sets. |
| | | |
| | ITEMS | Displays information about the data items in the |
| | | database. Includes attributes and security. |
| | | |
| | PASSWORDS | Displays information about the user classes and |
| | | associated passwords in the database. |
| | | |
| | PATHS | Displays information about the paths in a data set. |
| | | Includes key item, linked data set, and sort item. |
| | | |
| | SETS | Displays information about the data sets in the |
| | | database. Includes data set type, capacity, |
| | | blocking factor, block length, device class, and |
| | | security. |
| | | |
-----------------------------------------------------------------------------------------------