HP 3000 Manuals HP 3000 Manuals
Reordering a Field in a Data Set
To reorder the field list sequence in a manual master or detail data set,
use the REORDER FIELD command. In this section, the fields in the data
set INVENTORY in the ORDERS database are reordered. Before reordering,
the REVIEW FIELDS output looks like this:
Data Set No.: 6 Name: INVENTORY Type: D
Fld No. Field Name Pr Sr So Master Set Name Sort Item Name
--------------------------------------------------------------------
1 STOCK# Y PRODUCT
2 ONHANDQTY
3 STORE#
4 SUPPLIER Y Y SUP-MASTER
5 UNIT-COST
6 LASTSHIPDATE Y DATE-MASTER
7 BINNUM Y BINNUM-MASTER <---- field to be reordered
In the example below, the field BINNUM is reordered to appear before the
field ONHANDQTY in the field list. The DBCPLUS program displays a
message confirming that the fields are reordered.
>reorder field inventory binnum onhandqty
Reorder of fields accepted.
>
To verify that the fields in the INVENTORY data set are reordered, use
the REVIEW FIELDS command as shown below. You can see that the field
BINNUM now appears before the field ONHANDQTY in the field list.
>review fields inventory
REVIEW FIELDS (DETAIL SET):
Data Set No.: 6 Name: INVENTORY Type: D
Fld No. Field Name Pr Sr So Master Set Name Sort Item Name
--------------------------------------------------------------------
1 STOCK# Y PRODUCT
2 BINNUM Y BINNUM-MASTER <---- field reordered
3 ONHANDQTY
4 STORE#
5 SUPPLIER Y Y SUP-MASTER
6 UNIT-COST
7 LASTSHIPDATE Y DATE-MASTER