HP 3000 Manuals HP 3000 Manuals
Deleting a Path from a Detail Data Set
To delete a path from a detail data set, use the DELETE PATH command. In
this section, the path associated with the FILL-DATE search item is
deleted from the SALES detail data set in the ORDERS database. Note that
the search item is not actually deleted from the data set; however, it is
no longer a search item. Before deleting the path, the REVIEW PATHS
command output looks like this:
DATA SET NO: 4 NAME: SALES TYPE: D
SEARCH ITEM NAME MASTER SET NAME SORT ITEM NAME PRIMARY
================ ================ ================ =======
ACCOUNT CUSTOMER PURCH-DATE
STOCK# PRODUCT
PURCH-DATE DATE-MASTER
DELIV-DATE DATE-MASTER
FILL-DATE DATE-MASTER STOCK# Y <---- *
*The path associated with the search item FILL-DATE will be deleted.
>
In the example below, SALES is the name of the data set containing the
path to be deleted. FILL-DATE is the search item associated with the
path to be deleted. DBChange displays a message confirming the deletion
of the path.
>delete path sales fill-date
Deletion of path accepted.
>
Refer to "DELETE PATH" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command syntax and parameters.
If you want to verify the deletion of a path, use the REVIEW PATHS
command. In the following example, you can see that the path associated
with the FILL-DATE search item is deleted:
>review paths sales
DATABASE NAME: ORDERS
REVIEW PATHS (FOR DETAIL DATA SET):
DATA SET NO: 4 NAME: SALES TYPE: D
SEARCH ITEM NAME MASTER SET NAME SORT ITEM NAME PRIMARY
================ ================ ================ =======
ACCOUNT CUSTOMER PURCH-DATE Y
STOCK# PRODUCT
PURCH-DATE DATE-MASTER
DELIV-DATE DATE-MASTER
<---- *
* The path associated with the search item FILL-DATE has been deleted
from the data set.
>
NOTE After deleting a primary path, DBChange Plus automatically
designates the path associated with the first search key in the
detail data set as the new primary path. To change this, use the
CHANGE PRIMARYPATH command discussed earlier in this chapter.