HP 3000 Manuals HP 3000 Manuals
DELETE ITEM
Deletes a data item and its associated fields and paths from the
database.
Syntax
D[ELETE] ITEM DataItemName
Parameters
DataItemName is the name of the data item to be deleted.
Description
Use this command to delete a data item from the ITEMS part of the schema
and from any data set in which it is used as a field.
CAUTION The deletion of a data item causes loss of data and, if the data
item is a search item, deletion of paths associated with the
search item. Any automatic master containing the data item is
also deleted. Therefore, use caution when deleting data items,
especially if the data item is used as a sort or search item.
In interactive mode you are required to confirm the deletion of the data
item; in batch mode no confirmation is required.
If you only want to delete a field from a specific data set, use the
DELETE FIELD command. If the data item to be deleted is a sort item, you
must first use the DELETE SORT command.
Example
>delete item zip
In this example, the data item ZIP is deleted from the database. Before
the deletion, the ITEMS and SETS parts of the schema look like this:
ITEMS:
ACCOUNT , J2(0,11,12,13,14,18/);
BINNUM , Z2(/13);
:
UNIT-COST , P8(/12);
ZIP , X6(12,13,14/11); <---- to be deleted
SETS:
NAME: CUSTOMER ,M(14/11,18);
ENTRY: ACCOUNT (1) ,
LAST-NAME ,
:
STATE ,
ZIP , <---- to be deleted
CREDIT-RATING ;
CAPACITY: 221(10);
NAME: DATE-MASTER ,A(0,11,12,13,14,18/);
ENTRY: DATE (3) ;
CAPACITY: 211(9);
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: STOCK# (2) ,
DESCRIPTION ;
CAPACITY: 307(16);
:
NAME: SUP-MASTER ,M(13/12,18);
ENTRY: SUPPLIER (1) ,
:
ZIP ; <---- to be deleted
CAPACITY: 211(12);
:
END.
After the deletion, the ITEMS and SETS parts of the schema look like
this:
ITEMS:
ACCOUNT , J2(0,11,12,13,14,18/);
BINNUM , Z2(/13);
:
UNIT-COST , P8(/12); <---- ZIP deleted here
SETS:
NAME: CUSTOMER ,M(14/11,18);
ENTRY: ACCOUNT (1) ,
LAST-NAME ,
:
STATE , <---- ZIP deleted here
CREDIT-RATING ;
CAPACITY: 221(10);
NAME: DATE-MASTER ,A(0,11,12,13,14,18/);
ENTRY: DATE (3) ;
CAPACITY: 211(19);
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: STOCK# (2) ,
DESCRIPTION ;
CAPACITY: 307(16);
:
NAME: SUP-MASTER ,M(13/12,18);
ENTRY: SUPPLIER (1) ,
:
STATE ; <---- ZIP deleted here
CAPACITY: 211(12);
:
END.