HP 3000 Manuals

REVIEW FIELDS [ DBChange Plus User's Guide ] MPE/iX 5.0 Documentation


DBChange Plus User's Guide

REVIEW FIELDS 

Displays information about the fields (data items) in a master and detail
data set.

Syntax 

     REV[IEW] F[IELDS] DataSetName 

Parameters 

DataSetName         is the name of a data set that contains fields to be
                    reviewed.

Description 

Use this command to review fields (data items) in a data set.  For a
master data set, the following information is displayed:

Data Set No.          is the sequence in which the data set appears in
                      the SETS part of the schema.

Name                  is the data set name.

Type                  is the type of data set.  Valid data set types are
                      as follows:

                      A       is for automatic master data set.

                      M       is for manual master data set.

                      D       is for detail data set.

Fld No.               is the sequence in which the field appears in the
                      data set.

Field Name            is the name of the field.

Detail Set Name       is the name of the related detail data set.

Path's Search Item    is the name of the key item by which the master
                      data set is linked to a detail data set.

For a detail data set, the information displayed is similar to that of a
master data set, except that paths are described along with the names of
the related master data sets.  The primary path and any sort items are
also indicated.  All changes stored in the the current change file are
included in the REVIEW FIELDS output.

Example 

     >review fields product 

     REVIEW FIELDS (MASTER SET):

       Data Set No.:  3   Name:  PRODUCT   Type:  M

       Fld No.  Field Name        Detail Set Name   Path's Search Item
       ---------------------------------------------------------------

       1        STOCK#            SALES             STOCK#
                                  INVENTORY         STOCK#
       2        DESCRIPTION
       3        DISC-PRICE

     >

In this example, the fields in the master data set PRODUCT are reviewed.
The data set PRODUCT contains three fields, STOCK#, DESCRIPTION, and
DISC-PRICE. The key item, STOCK#, defines paths to two detail data sets,
SALES and INVENTORY.



MPE/iX 5.0 Documentation