HP 3000 Manuals HP 3000 Manuals
Adding a Master Data Set
To add an automatic or manual master data set to the database, use the
ADD SET command. In this section, the new data set BINNUM-MASTER is
added to the ORDERS database. Before adding a 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 INVENTORY D 450 15 481 DISK2 (12,14/13,18)
6 SALES D 500 10 371 DISK2 (11/14,18)
In the example below, the master data set BINNUM-MASTER is added. It
will appear before the INVENTORY data set in the data set list.
BINNUM-MASTER is an automatic master data set. The key item is BINNUM.
Note that the key item must already exist in the data item list of the
database. User class 14 has read access; user classes 11 and 18 have
write access. The data set capacity is 220. The blocking factor is 12,
and the device class is DISK1. The DBCPLUS program displays a message
confirming the addition of the new data set.
>add set binnum-master (inventory) a binnum (14/11,18) 220 (12) disk1
Addition of data set accepted.
>
Refer to "ADD SET" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command syntax and parameters.
Because TurboIMAGE/XL does not allow stand-alone automatic master data
sets, after adding the master data set BINNUM-MASTER, you must add a path
to connect the automatic master data set to a detail data set. To do
this, use the ADD PATH command. The example below adds a path from the
detail data set INVENTORY. The search item is STOCK#, and BINNUM-MASTER
is specified as the master data set to which the detail data set is
linked. The DBCPLUS program displays a message confirming the addition
of the path.
>add path inventory stock# binnum-master
Addition of path accepted.
>
After adding a master data set and a path, the new data set contains only
one field--the key item. To add more fields, use the ADD FIELD command
discussed later in this chapter. To connect the new key item to other
detail data sets, use the ADD PATH command.
Refer to "ADD PATH" in chapter 6, "Changing Paths in a Detail Data Set,"
or in chapter 10, "DBChange Plus Commands."
If you want to verify the addition of the new 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
master data set BINNUM-MASTER is added.
>review sets @
REVIEW SETS:
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 0 DISK1 (14/11,18) <---- *
6 INVENTORY D 450 15 481 DISK2 (12,14/13,18)
7 SALES D 500 10 371 DISK2 (11/14,18)
*data set added