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