HP 3000 Manuals

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


DBChange Plus User's Guide

REVIEW PATHS 

Displays information about the paths in a data set.

Syntax 

     REV[IEW] PAT[HS] DataSetName 

Parameters 

DataSetName         is the name of the master or detail data set whose
                    paths you want to review.

Description 

Use this command in interactive and batch mode to review the paths in a
data set.  For detail data sets, 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 name of the detail data set being
                          reviewed.

Type                      is the type of data set.  D is for a detail
                          data set.

Search Item Name          is the name of the search item linking the
                          detail data set to a master data set.

Master Set Name           is the name of the master data set to which the
                          detail data set is associated.

Sort Item Name            is the name of the sort item.

Primary                   indicates the primary path.

For master data sets, 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 name of the master data set being
                          reviewed.

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

                          A       is for automatic master data set.

                          M       is for manual master data set.

Key(Search) Item          is the key item that connects the master data
                          set to the related detail data set.

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

Sort Item Name            is the name of the sort item.

All changes stored in the the current change file are included in the
REVIEW PATHS output.  The REVIEW PATHS command also displays status
messages if a CHECK PATH or FIX PATH command is pending.

Example 1 

     >review paths inventory 

     REVIEW PATHS (DETAIL SET):

       Data Set No.:  6   Name:  INVENTORY   Type:  D

       Search Item Name   Master Set Name    Sort Item Name     Primary
       ----------------------------------------------------------------

       STOCK#             PRODUCT
       SUPPLIER           SUP-MASTER                               Y
       LASTSHIPDATE       DATE-MASTER

     >

In this example, the paths for the detail data set INVENTORY are
reviewed.  The data set number is 6.  The search item SUPPLIER represents
the primary path.  No sort items are identified for any of the paths.

Example 2 

     >review path customer 

     REVIEW PATHS (MASTER SET):

       Data Set No.:  2   Name:  CUSTOMER   Type:  M

       Key(Search) Item   Detail Set Name    Sort Item Name
       ------------------------------------------------------

       ACCOUNT            SALES              PURCH-DATE

     >

In this example, the paths for the master data set CUSTOMER are reviewed.
The data set number is 2.  The key item is ACCOUNT, the related detail
data set is SALES, and the sort item is PURCH-DATE.



MPE/iX 5.0 Documentation