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