HP 3000 Manuals HP 3000 Manuals
Deleting a Sort Item from a Detail Data Set
To remove a sort item from a search item in a detail data set, use the
DELETE SORT command. In this section, a sort item is removed from the
search item SUPPLIER in the detail data set INVENTORY. Before deleting
the sort item, the REVIEW PATHS command output looks like this:
DATA SET NO: 6 NAME: INVENTORY TYPE: D
SEARCH ITEM NAME MASTER SET NAME SORT ITEM NAME PRIMARY
================ ================ ================ =======
STOCK# PRODUCT Y
SUPPLIER SUP-MASTER LASTSHIPDATE
LASTSHIPDATE DATE-MASTER
>
In the example below, INVENTORY is the name of the data set containing
the sort item to be deleted. SUPPLIER is the name of the search item
containing the sort item to be deleted. This command does not delete the
LASTSHIPDATE field from the data set; it only removes its role as a sort
item. The DBCPLUS program displays a message confirming the deletion of
the sort item.
>delete sort inventory supplier
Deletion of sort item accepted.
>
Refer to "DELETE SORT" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command syntax and parameters.
If you want to verify the deletion of the sort item, use the REVIEW PATHS
command. In the following example, you can see that LASTSHIPDATE sort
item is deleted:
>review paths inventory
DATABASE NAME: ORDERS
REVIEW PATHS (FOR DETAIL DATA SET):
DATA SET NO: 6 NAME: INVENTORY TYPE: D
SEARCH ITEM NAME MASTER SET NAME SORT ITEM NAME PRIMARY
================ ================ ================ =======
STOCK# PRODUCT Y
SUPPLIER SUP-MASTER <---- *
LASTSHIPDATE DATE-MASTER
*The sort item LASTSHIPDATE has been deleted from the data set.
>