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