HP 3000 Manuals HP 3000 Manuals
Deleting a Data Set
To delete a master or detail data set and its associated paths from the
database, use the DELETE SET command. In this section, the data set
BINNUM-MASTER is deleted from the ORDERS database. Before deleting the
data set, the REVIEW SETS command output looks like this:
Set Blk Blk Dev
No. Data Set Name Type Capacity Fac Max Class Security
--------------------------------------------------------------
1 DATE-MASTER A 365 19 496 DISK1
2 CUSTOMER M 201 10 640 DISK1 (14/11,18)
3 PRODUCT M 300 16 498 DISK1 (13,14/12,18)
4 SUP-MASTER M 201 12 505 DISK1 (13/12,18)
5 BINNUM-MASTER A 220 12 145 DISK1 (14/11,18) <---- *
6 INVENTORY D 450 15 640 DISK2 (12,14/13,18)
7 SALES D 500 10 371 DISK2 (11/14,18)
*data set to be deleted
In the example below, the data set BINNUM-MASTER is deleted. In an
interactive session, a message is displayed asking you to confirm the
deletion of the data set. In batch mode (as shown below), the data set
is deleted without confirmation. The DBCPLUS program displays a message
confirming the deletion of the data set.
>delete set binnum-master
Deletion of data set accepted.
>
NOTE If you delete all detail data sets that are connected to an
automatic master data set, the automatic master data set to which
they are connected is also deleted.
Refer to "DELETE SET" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command syntax and parameters.
If you want to verify the deletion of the data set, use the REVIEW SETS
command. In the following example, the @ parameter is used to display
all the data sets in the ORDERS database. You can see that the data set
BINNUM-MASTER is deleted.
Set Blk Blk Dev
No. Data Set Name Type Capacity Fac Max Class Security
--------------------------------------------------------------
1 DATE-MASTER A 365 19 496 DISK1
2 CUSTOMER M 201 10 640 DISK1 (14/11,18)
3 PRODUCT M 300 16 498 DISK1 (13,14/12,18)
4 SUP-MASTER M 201 12 505 DISK1 (13/12,18) <---- *
5 INVENTORY D 450 15 640 DISK2 (12,14/13,18)
6 SALES D 500 10 371 DISK2 (11/14,18)
*data set deleted