HP 3000 Manuals HP 3000 Manuals
DELETE FIELD
Deletes a field from a manual master or detail data set.
Syntax
D[ELETE] F[IELD] DataSetName FieldName
Parameters
DataSetName is the name of the data set from which the field is
to be deleted.
FieldName is the name of the field to be deleted.
Description
Use this command to delete a field from a manual master or detail data
set.
CAUTION The deletion of a field will cause loss of data.
If you are deleting a search item, you must delete the path before you
can delete the field. Refer to "DELETE PATH" later in this chapter.
When you delete a field, the ITEMS part of the database schema and other
data sets are not affected.
If you are deleting a sort item, you must delete the sort item before
deleting the field. Refer to "DELETE SORT" later in this chapter.
Example
>delete field product description
In this example, the field DESCRIPTION is deleted from the PRODUCT data
set.
Before the deletion, the data set PRODUCT data set entry in the schema
looks like this:
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: STOCK# (2) ,
DESCRIPTION ; <---- field to be deleted
CAPACITY: 307(16);
After the deletion, the data set entry in the schema looks like this:
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: STOCK# (2) ; <---- field deleted after STOCK#
CAPACITY: 307(16);