HP 3000 Manuals HP 3000 Manuals
REORDER ITEM
Reorders the sequence in which the data item resides in the database.
Syntax
REO[RDER] ITEM DataItemName [( NextDataItem)]
Parameters
DataItemName is the name of the data item to be reordered.
(NextDataItem) is the data item that follows the newly reordered
data item in the schema data item list. If this
parameter is omitted, the reordered data item is
placed last.
Description
Use this command to reorder the data item sequence in the data item part
of the schema. The data item must be an existing data item in the
database. Use the NextDataItem parameter to specify where you wish to
place the reordered field. If you wish the reordered data item to appear
in last place, omit the NextDataItem parameter.
Example
>reorder item store# street-add
In this example, the data item STORE# is reordered to appear before the
data item STREET-ADD in the schema data item list.
Before the reorder, the schema data item list looks like this:
ITEMS:
ACCOUNT , J2(0,11,12,13,14,18/);
BINNUM , Z2(/13);
CITY , X12(12,13,14,/11);
CREDIT-RATING , R2(/14);
DATE , X6(0,11,12,13,14,18/);
DELIV-DATE , X6((/14);
DESCRIPTION , X20(0,11,12,13,14,18/);
FIRST-NAME , X10(14/11);
INITIAL , U2(14/11);
LAST-NAME , X16(14/11);
LASTSHIPDATE , X6(12/);
ONHANDQTY , J2(14/12);
PRICE , J2(14/);
PURCH-DATE , X6(11/14);
QUANTITY , I1(/14);
STATE , X2(12,13,14,/11);
STOCK# , U8(0,11,12,13,14,18/);
STREET-ADD , S26(12,13,14/11);
SUPPLIER , X16(12,13/);
TAX , J2(14/);
TOTAL , J2(11,14);
UNIT-COST , P8(/12);
ZIP , X6(12,13,14/11);
STORE# , J2(11,12/14); <---- item to be reordered
After the reorder, the ITEMS part of the schema looks like this:
ITEMS:
ACCOUNT , J2(0,11,12,13,14,18/);
BINNUM , Z2(/13);
CITY , X12(12,13,14,/11);
CREDIT-RATING , R2(/14);
DATE , X6(0,11,12,13,14,18/);
DELIV-DATE , X6((/14);
DESCRIPTION , X20(0,11,12,13,14,18/);
FIRST-NAME , X10(14/11);
INITIAL , U2(14/11);
LAST-NAME , X16(14/11);
LASTSHIPDATE , X6(12/);
ONHANDQTY , J2(14/12);
PRICE , J2(14/);
PURCH-DATE , X6(11/14);
QUANTITY , I1(/14);
STATE , X2(12,13,14,/11);
STOCK# , U8(0,11,12,13,14,18/);
STORE# , J2(11,12/14); <---- item reordered
STREET-ADD , S26(12,13,14/11);
SUPPLIER , X16(12,13/);
TAX , J2(14/);
TOTAL , J2(11,14);
UNIT-COST , P8(/12);
ZIP , X6(12,13,14/11);