HP 3000 Manuals HP 3000 Manuals
DELETE SET
Deletes a master or detail data set and all associated paths from a
database.
Syntax
D[ELETE] SET DataSetName
Parameters
DataSetName is the name of the data set to be deleted.
Description
Use this command to delete a data set and its associated paths from a
database. The deletion of a data set causes loss of data. If the data
set contains the only path to an automatic master, the path and the
automatic master are also deleted. Therefore, use caution when deleting
data sets. In interactive mode you are required to confirm the deletion
of the data set; in batch mode no confirmation is required.
Example
>delete set inventory
This example deletes the detail data set INVENTORY and its related path
from the database.
Before the deletion, the SETS part of the schema looks like this:
SETS:
NAME: CUSTOMER ,M(14/11,18);
ENTRY: ACCOUNT (1) ,
LAST-NAME ,
FIRST-NAME ,
INITIAL ,
STREET ,
CITY ,
STATE ,
ZIP ,
CREDIT-RATING ;
CAPACITY: 221(10);
NAME: DATE-MASTER ,A(0,11,12,13,14,18/);
ENTRY: DATE (3) ; <---- path count to change
CAPACITY: 211(9);
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: STOCK# (2) , <---- path count to change
DESCRIPTION ;
CAPACITY: 307(16);
NAME: SALES ,D(11/14,18);
ENTRY: ACCOUNT ( CUSTOMER (PURCH-DATE )),
STOCK# (!PRODUCT ),
QUANTITY ,
PRICE ,
TAX ,
TOTAL ,
PURCH-DATE ( DATE-MASTER ),
DELIV-DATE ( DATE-MASTER );
CAPACITY: 504(14);
NAME: SUP-MASTER ,M(13/12,18);
ENTRY: SUPPLIER (1) , <---- path count to change
STREET-ADD ,
CITY ,
STATE ,
ZIP ;
CAPACITY: 211(12);
NAME: INVENTORY ,D(12,14/13,18); <---- to be deleted
ENTRY: STOCK# (PRODUCT ),
ONHANDQTY ,
SUPPLIER (!SUP-MASTER ),
UNIT-COST ,
LASTSHIPDATE ( DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);
END.
After the deletion, the SETS part of the schema looks like this:
SETS:
NAME: CUSTOMER ,M(14/11,18);
ENTRY: ACCOUNT (1) ,
LAST-NAME ,
FIRST-NAME ,
INITIAL ,
STREET ,
CITY ,
STATE ,
ZIP ,
CREDIT-RATING ;
CAPACITY: 221(10);
NAME: DATE-MASTER ,A(0,11,12,13,14,18/);
ENTRY: DATE (2) ; <---- path count changed
CAPACITY: 211(9);
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: STOCK# (1) , <---- path count changed
DESCRIPTION ;
CAPACITY: 307(16);
NAME: SALES ,D(11/14,18);
ENTRY: ACCOUNT ( CUSTOMER (PURCH-DATE )),
STOCK# (!PRODUCT ),
QUANTITY ,
PRICE ,
TAX ,
TOTAL ,
PURCH-DATE ( DATE-MASTER ),
DELIV-DATE ( DATE-MASTER );
CAPACITY: 504(14);
NAME: SUP-MASTER ,M(13/12,18);
ENTRY: SUPPLIER , <---- path count changed
STREET-ADD ,
CITY ,
STATE ,
ZIP ;
CAPACITY: 211(12); <---- INVENTORY deleted
here
END.