HP 3000 Manuals

DELETE SORT [ DBChange Plus User's Guide ] MPE/iX 5.0 Documentation


DBChange Plus User's Guide

DELETE SORT 

Deletes a sort item from a search item in a detail data set.

Syntax 

     D[ELETE] SO[RT] DataSetName SearchItemName 

Parameters 

DataSetName         is the name of the data set containing the sort item
                    to be deleted.

SearchItemName      is the name of the search item associated with the
                    sort item to be deleted.

Description 

Use this command to delete a sort item from a path in a detail data set.
When a sort item is associated with a particular path, the search item
that defines the path is entered, rather than the sort item name itself.

Example 

     >delete sort sales account 

In this example, the sort item PURCH-DATE is deleted from the data set
SALES.

Before the deletion, the data set entry in the schema looks like this:

     NAME:      SALES        ,D(11/14,18);
     ENTRY:     ACCOUNT     ( CUSTOMER (PURCH-DATE )),    <---- sort item to be deleted 
                STOCK#      (!PRODUCT               ),
                QUANTITY                             ,
                PRICE                                ,
                TAX                                  ,
                TOTAL                                ,
                PURCH-DATE ( DATE-MASTER            ),
                DELIV-DATE ( DATE-MASTER            ),
     CAPACITY:  504(14);

After the deletion, the data set entry in the schema looks like this:

     NAME:      SALES   ,D(11/14,18);
     ENTRY:     ACCOUNT     ( CUSTOMER              ),    <---- sort item deleted 
                STOCK#      (!PRODUCT               ),
                QUANTITY                             ,
                PRICE                                ,
                TAX                                  ,
                TOTAL                                ,
                PURCH-DATE ( DATE-MASTER            ),
                DELIV-DATE ( DATE-MASTER            ),
     CAPACITY:  504(14);



MPE/iX 5.0 Documentation