HP 3000 Manuals HP 3000 Manuals
Using REVIEW Commands to Display Information about the Database
The DBCPLUS program has several REVIEW commands that display information
about the database structure with the changes stored in a change file.
The remainder of this chapter provides an example for each REVIEW
command.
Displaying User Classes and Passwords
To display one or more user classes and associated passwords in the
database, use the REVIEW PASSWORDS command. In the following example, @
is the parameter used to display all user classes and associated
passwords in the ORDERS database:
>review passwords @
REVIEW PASSWORDS:
User Class Password
-----------------------
11 CREDIT
12 BUYER
13 SHIP-REC
14 CLERK
18 DO-ALL
>
Refer to "REVIEW PASSWORDS" in chapter 10, "DBChange Plus Commands," for
a detailed description of the command.
Displaying Data Items
To display information about one or more data items in the database, use
the REVIEW ITEMS command. The REVIEW ITEMS command displays item numbers
as they appear in the schema, along with their item name, attributes, and
security information. In the following example, @ is the parameter used
to display all the items in the ORDERS database. Because the database
has more than 20 data items, the DBCPLUS program asks if you want to
continue, that is, review more data items.
>review items @
REVIEW ITEMS:
Itm No. Item Name Attrib Security
------------------------------------------
1 ACCOUNT I4 (11,12,13,14,18/)
2 BINNUM Z2 (/13)
3 CITY X12 (12,13,14/11)
4 CREDIT-RATING R2 (/14)
5 DATE X6 (11,12,13,14,18/)
6 DELIV-DATE X6 (/14)
7 DESCRIPTION X20 (11,12,13,14,18/)
8 FIRST-NAME X10 (14/11)
9 INITIAL U2 (14/11)
10 LAST-NAME X16 (14/11)
11 LASTSHIPDATE X6 (12/)
12 ONHANDQTY J2 (14/12)
13 PRICE J2 (14/)
14 PURCH-DATE X6 (11/14)
15 QUANTITY I1 (/14)
16 STATE X2 (12,13,14/11)
17 STOCK# U8 (11,12,14,18/)
18 STREET-ADD X26 (12,13,14/11)
19 SUPPLIER X16 (12,13/)
20 TAX J2 (14/)
CONTINUE [y/N] ? Return
>
Refer to "REVIEW ITEMS" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command.
Displaying Information about Data Sets
This section describes the REVIEW commands used to display information
about data sets.
Displaying Data Sets.
To display information about one or more data sets in the database, use
either the REVIEW SETS or REVIEW BLOCKS command. Both the REVIEW SETS
and REVIEW BLOCKS commands display the data set name, the data set type,
capacity, blocking factor and maximum block length. The REVIEW SETS
command also displays the data set number as it appears in the schema,
the device class, and the security information; while the REVIEW BLOCKS
command displays field count, path count, data entry length with and
without chain counters and pointers, media records, and block length.
Note that the information displayed in the REVIEW BLOCKS command is
similar to the data set summary table printed by the schema processor.
In the following example, REVIEW SETS is used to display information
about the data set PRODUCT in the ORDERS database:
>review sets product
REVIEW SETS:
Set Blk Blk Dev
No. Data Set Name Type Capacity Fac Max Class Security
--------------------------------------------------------------
2 PRODUCT M 307 16 498 (13,14/12,18)
>
In the example below, the REVIEW BLOCKS command is used to display
information about the data set PRODUCT in the ORDERS database:
>review blocks product
REVIEW BLOCKS:
Fld Pth Entr Med Blk Blk Blk
Data Set Name Type Cnt Cnt Len Rec Capacity Fac Len Max
-----------------------------------------------------------------
PRODUCT M 2 2 14 31 307 16 498 498
>
Refer to "REVIEW SETS" and "REVIEW BLOCKS" in chapter 10, "DBChange Plus
Commands," for a detailed description of the commands.
Displaying Fields.
To display one or more fields in a data set, use the REVIEW FIELDS
command. For both master and detail data sets, the REVIEW FIELDS command
displays the data set number, as it appears in the schema, and the data
set name and type. However, the master data set output differs from the
detail data set output in that the master data set output displays the
detail data set associated with the master data set and the search item
linking that detail data set to the master data set. In the detail data
set output, the REVIEW FIELDS command flags the primary path, search
items, and sort item; it also displays the names of the master data set
to which the detail data set is linked and the sort item name.
In the following example, the REVIEW FIELDS command is used to display
the fields in the master data set CUSTOMER in the ORDERS database:
>review fields customer
REVIEW FIELDS (MASTER SET):
Data Set No.: 2 Name: CUSTOMER Type: M
Fld No. Field Name Detail Set Name Path's Search Item
---------------------------------------------------------------
1 ACCOUNT SALES ACCOUNT
2 LAST-NAME
3 FIRST-NAME
4 INITIAL
5 STREET-ADD
6 CITY
7 STATE
8 ZIP
9 CREDIT-RATING
>
In the example below, the REVIEW FIELDS command is used to display the
fields in the detail data set SALES:
>review fields sales
REVIEW FIELDS (DETAIL SET):
Data Set No.: 6 Name: SALES Type: D
Fld No. Field Name Pr Sr So Master Set Name Sort Item Name
--------------------------------------------------------------------
1 ACCOUNT Y CUSTOMER PURCH-DATE
2 STOCK# Y Y PRODUCT
3 QUANTITY
4 PRICE
5 TAX
6 TOTAL
7 PURCH-DATE Y Y DATE-MASTER
8 DELIV-DATE Y DATE-MASTER
>
Refer to "REVIEW FIELDS" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command.
Displaying Paths.
To display information about the paths in one or more data sets, use the
REVIEW PATHS command. For both master and detail data sets, the REVIEW
PATHS command displays the data set number, as it appears in the schema,
and the data set name and type. However, the master data set output
differs from the detail data set output in that the master data set
output displays the key item, the detail data set linked to the master
data set, and the sort item name. In the detail data set output, the
REVIEW PATHS command displays the search item name linking the detail
data set to the master data set, the master data set to which the detail
data set is linked, the sort item name, and the primary path.
In the following example, CUSTOMER is the name of a master data set in
the ORDERS database:
>review paths customer
REVIEW PATHS (MASTER SET):
Data Set No.: 1 Name: CUSTOMER Type: M
Key(Search) Item Detail Set Name Sort Item Name
------------------------------------------------------
ACCOUNT SALES PURCH-DATE
>
In the example below, SALES is the name of a detail data set in the
ORDERS database:
>review paths sales
REVIEW PATHS (DETAIL SET):
Data Set No.: 3 Name: SALES Type: D
Search Item Name Master Set Name Sort Item Name Primary
----------------------------------------------------------------
ACCOUNT CUSTOMER PURCH-DATE
STOCK# PRODUCT Y
>
Refer to "REVIEW PATHS" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command.