HP 3000 Manuals HP 3000 Manuals
Reordering a Data Set
To reorder the sequence of data sets in the data set list, use the
REORDER SET command. In this section, the data set BINNUM-MASTER in the
ORDERS database is reordered. Before reordering 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 INVENTORY D 450 15 481 DISK2 (12,14/13,18)
6 SALES D 500 10 371 DISK2 (11/14,18)
7 BINNUM-MASTER A 220 12 0 DISK1 (14/11,18) <---- *
* data set to be reordered
In the example below, the data set BINNUM-MASTER is reordered to appear
before the data set CUSTOMER in the data set list. (When the nextset
parameter is omitted, the data set appears at the end of the data set
list.) The DBCPLUS program displays a message confirming that the data
sets are reordered.
>reorder set binnum-master customer
Reorder of data set accepted.
>
Refer to "REORDER SET" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command syntax and parameters.
To verify that the data sets are reordered, 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
now appears before the data set CUSTOMER in the data set list.
>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 BINNUM-MASTER A 220 12 0 DISK1 (14/11,18) <---- *
3 CUSTOMER M 201 10 640 DISK1 (14/11,18)
4 PRODUCT M 300 16 498 DISK1 (13,14/12,18)
5 SUP-MASTER M 201 12 505 DISK1 (13/12,18)
6 INVENTORY D 450 15 481 DISK2 (12,14/13,18)
7 SALES D 500 10 371 DISK2 (11/14,18)
*data set reordered