HP 3000 Manuals HP 3000 Manuals
REORDER FIELD
Reorders the field sequence in a manual master or detail data set.
Syntax
REO[RDER] F[IELD] DataSetName FieldName [ (NextField) ]
Parameters
DataSetName is the name of the data set which contains the field
to be reordered.
FieldName is the name of the field to be reordered. It must be
an existing field in the data set.
(NextField) is the existing field that follows the newly
reordered field in the field list for the data set.
If this parameter is omitted, the reordered field is
placed last.
Description
Use this command to reorder the field (data item) sequence in a manual
master or detail data set field list. The field must already be an
existing field in the data set. Use the NextField parameter to specify
where you want to place the reordered field. If you want the reordered
field to appear in last place, omit the NextField parameter.
Example
>reorder field inventory unit-cost binnum
This example reorders the field UNIT-COST in the INVENTORY data set. The
field will appear directly before BINNUM in the field listing for the
data set.
Before the reorder, the schema entry for INVENTORY looks like this:
NAME: INVENTORY ,D(12,14/13);
ENTRY: STOCK# (PRODUCT ),
ONHANDQTY ,
SUPPLIER (!SUP-MASTER ),
UNIT-COST , <---- field to be reordered
LASTSHIPDATE ( DATE-MASTER ),
BINNUM ;
CAPACITY: 450(15);
After the reorder, the data set entry in the schema looks like this:
NAME: INVENTORY ,D(12,14/13);
ENTRY: STOCK# ( PRODUCT ),
ONHANDQTY ,
SUPPLIER (!SUP-MASTER ),
LASTSHIPDATE ( DATE-MASTER ),
UNIT-COST , <---- field reordered
BINNUM ;
CAPACITY: 450(15);