HP 3000 Manuals HP 3000 Manuals
REORDER SET
Reorders the sequence in which the data set resides in the database.
Syntax
REO[RDER] SET DataSetName [( NextDataSet)]
Parameters
DataSetName is the name of the data set to be reordered. It must
be an existing data set in the database.
(NextDataSet) is the existing data set that follows the newly
reordered data set in the schema data set list. If
this parameter is omitted, the reordered data set is
placed last.
Description
Use this command to reorder the data set sequence in the data set part of
the schema. It must be an existing data set in the database. Use the
NextDataSet parameter to specify where you wish to place the reordered
data set. If you wish the reordered data set to appear in last place,
omit the NextDataSet parameter.
NOTE When reordering data sets, remember that all master data sets must
appear in the schema before their related detail data sets.
Example
>reorder set sup-master sales
In this example, the data set SUP-MASTER is reordered to appear before
the data set SALES in the schema data set list.
Before the reorder, the schema data set list looks like this:
SETS:
NAME: CUSTOMER ,M(14/11,18);
ENTRY: ACCOUNT (1) ,
LAST-NAME ,
FIRST-NAME ,
INITIAL ,
STREET-ADD ,
CITY ,
STATE ,
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: SALES ,D(11/14,18)
ENTRY: ACCOUNT ( CUSTOMER (PURCH-DATE) )
STOCK# (!PRODUCT )
QUANTITY
PRICE
TAX
TOTAL
PURCH-DATE ( DATE-MASTER )
DELIV-DATE ( DATE-MASTER )
CAPACITY: 504(14)
NAME: SUP-MASTER ,M(13/12,18); <---- data set to
ENTRY: SUPPLIER (1) , be reordered
STREET-ADD ,
CITY ,
STATE ,
ZIP ;
CAPACITY: 211(12);
NAME: INVENTORY ,D(12,14/13,18);
ENTRY: STOCK# (PRODUCT ),
ONHANDQTY ,
SUPPLIER (!SUP-MASTER ),
UNIT-COST ,
LASTSHIPDATE ( DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);
END.
After the reorder, the SETS part of the schema looks like this:
SETS:
NAME: CUSTOMER ,M(14/11,18);
ENTRY: ACCOUNT (1) ,
LAST-NAME ,
FIRST-NAME ,
INITIAL ,
STREET-ADD ,
CITY ,
STATE ,
CREDIT-RATING ;
CAPACITY: 221(10);
NAME: DATE-MASTER ,A(0,11,12,13,14,18/);
ENTRY: DATE (2) ;
CAPACITY: 211(19);
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: STOCK# (1) ,
DESCRIPTION ;
CAPACITY: 307(16);
NAME: SUP-MASTER ,M(13/12,18); <---- data set reordered
ENTRY: SUPPLIER ,
STREET-ADD ,
CITY ,
STATE ,
ZIP ;
CAPACITY: 211(12);
NAME: SALES ,D(11/14,18);
ENTRY: ACCOUNT ( CUSTOMER (PURCH-DATE) ),
STOCK# (!PRODUCT ),
QUANTITY ,
PRICE ,
TAX ,
TOTAL ,
PURCH-DATE ( DATE-MASTER ),
DELIV-DATE ( DATE-MASTER );
CAPACITY: 504(14);
NAME: INVENTORY ,D(12,14/13,18);
ENTRY: STOCK# (PRODUCT ),
ONHANDQTY ,
SUPPLIER (!SUP-MASTER ),
UNIT-COST ,
LASTSHIPDATE ( DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);
END.