HP 3000 Manuals HP 3000 Manuals
ADD PATH
Adds a path to a detail data set.
Syntax
A[DD] PAT[H] DetailDataSetName SearchItemName [!] MasterDataSetName [ SortItemName]
Parameters
DetailDataSetName is the name of the detail data set that will contain
the new path.
SearchItemName is the name of the search item for the new path.
! indicates that the new path is to be the primary
path. Only one path in a detail data set can be
designated as the primary path. If this parameter is
omitted, a primary path previously designated will
remain in effect. If no primary path has been
designated, the first unsorted path listed for the
data set in the schema becomes the primary path by
default. No space is allowed between ! and
MasterDataSetName.
MasterDataSetName is the master data set related to the search item.
It must be an existing data set and must be listed in
the schema before the specified detail data set
containing.
SortItemName is the name of the sort item for the new path. If
this parameter is omitted, the entries will not be
sorted. The sort item must be an existing field in
the detail data set.
Description
Use this command to add a new path to a detail data set. Place an
exclamation point (!) before the name of the master data set to define
the path as the primary path. The primary path should be the path in the
data set most frequently accessed. A newly defined primary path replaces
any existing primary path.
Note that a master data set must be listed in the schema before any
related detail data sets. Use the REORDER SET command if it is necessary
to reorder data sets.
Example
>add path inventory stock# !product
In this example, a new path is added to the detail data set INVENTORY and
is designated as the primary path. PRODUCT is the related master data
set. No sort item has been specified for the path. Use the REORDER SET
command if it is necessary to reorder data sets.
Before the addition, the schema entry for the INVENTORY data set looks
like this (note that the path to SUP-MASTER is the existing primary
path):
NAME: INVENTORY ,D(12,14/13,18);
ENTRY: STOCK# , <---- path to be added
ONHANDQTY ,
SUPPLIER (!SUP-MASTER ), <---- path to be changed
UNIT-COST ,
LASTSHIPDATE (DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);
After the addition, the schema entry for the INVENTORY data set looks
like this:
NAME: INVENTORY ,D(12,14/13,18);
ENTRY: STOCK# (!PRODUCT ), <---- primary path added
ONHANDQTY ,
SUPPLIER (SUP-MASTER ), <---- path no longer primary
UNIT-COST ,
LASTSHIPDATE (DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);