HP 3000 Manuals HP 3000 Manuals
DELETE PATH
Deletes a path from a detail data set to a master data set.
Syntax
D[ELETE] PAT[H] DataSetName SearchItemName
Parameters
DataSetName is the name of the detail data set of the path to be
deleted.
SearchItemName is the name of the search item defining the path to
be deleted.
Description
Use this command to delete a path between a detail data set and a master
data set. This command also changes the search item to a non-key item.
Note that you are not deleting the data item from the data set; you are
only deleting the path that the search item defined.
If the deleted path was the primary path in the data set, you may want to
redefine a new primary path using the CHANGE PATH command. If you do
not, the primary path defaults to the first unsorted path defined for the
data set.
If you delete a path that is the only path to an automatic master data
set, the automatic master data set is also deleted.
Example
>delete path inventory stock#
In this example, the path defined by the STOCK# search item in the detail
data set INVENTORY is deleted.
Before the deletion, the schema entry for the data set INVENTORY looks
like this:
NAME: INVENTORY ,D(12,14/13,18);
ENTRY: STOCK# (PRODUCT ), <---- path to be deleted
ONHANDQTY ,
SUPPLIER (!SUP-MASTER ),
UNIT-COST ,
LASTSHIPDATE ( DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);
After the deletion, the schema entry for the data set INVENTORY looks
like this:
NAME: INVENTORY ,D(12,14/13,18);
ENTRY: STOCK# , <---- path deleted
ONHANDQTY ,
SUPPLIER ),
UNIT-COST (!SUP-MASTER ),
LASTSHIPDATE ( DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);
After the deletion, STOCK# is still a data item in the data set
INVENTORY; however, it is no longer a search item.