HP 3000 Manuals HP 3000 Manuals
Reordering a Data Item
To reorder the data item sequence in the data item list, use the REORDER
ITEM command. In this section, the data item UNIT-COST is reordered in
the ORDERS database. Before reordering the data item, the REVIEW ITEMS
output looks like this:
Itm No. Item Name Attrib Security
------------------------------------------
1 ACCOUNT I4 (11,12,13,14,18/)
2 BINNUM Z2 (/13)
3 CITY X12 (12,13,14/11)
4 CREDIT-RATING R2 (/14)
5 DATE X6 (11,12,13,14,18/)
6 DELIV-DATE X6 (/14)
7 FIRST-NAME X10 (14/11)
8 INITIAL U2 (14/11)
9 LAST-NAME X16 (14/11)
10 LASTSHIPDATE X6 (12/)
11 ONHANDQTY J2 (14/12)
12 DESCRIPTION 4U25 (11,14/18)
13 PRICE J2 (14/)
14 PURCH-DATE X6 (11/14)
15 QUANTITY I1 (/14)
16 STATE X2 (12,13,14/11)
17 STOCK# X10 (11,12,14,18/)
18 STREET-ADD X26 (12,13,14/11)
19 VENDOR X16 (12,13/)
20 STORE# 8J2 (11,12/14)
21 TAX J2 (14/)
22 TOTAL J2 (11,14/)
23 UNIT-COST P8 (/12) <---- data item to be reordered
24 ZIP X6 (12,13,14/11)
In the example below, the data item UNIT-COST is reordered to appear
before the data item TAX in the data item list. If TAX were omitted, the
data item UNIT-COST would appear at the end of the data item list. The
DBCPLUS program displays a message confirming that the data items are
reordered.
>reorder item unit-cost (tax)
Reorder of data items accepted.
>
Refer to "REORDER ITEM" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command syntax and parameters.
If you want to verify that the data item has been reordered in the data
item list, use the REVIEW ITEMS command. In the following example, the @
parameter is used to display all the data items in the ORDERS database.
You can see that the data item UNIT-COST now appears before the data item
TAX in the data item list.
>review items @
REVIEW ITEMS:
Itm No. Item Name Attrib Security
------------------------------------------
1 ACCOUNT I4 (11,12,13,14,18/)
2 BINNUM Z2 (/13)
3 CITY X12 (12,13,14/11)
4 CREDIT-RATING R2 (/14)
5 DATE X6 (11,12,13,14,18/)
6 DELIV-DATE X6 (/14)
7 FIRST-NAME X10 (14/11)
8 INITIAL U2 (14/11)
9 LAST-NAME X16 (14/11)
10 LASTSHIPDATE X6 (12/)
11 ONHANDQTY J2 (14/12)
12 DESCRIPTION 4U25 (11,14/18)
13 PRICE J2 (14/)
14 PURCH-DATE X6 (11/14)
15 QUANTITY I1 (/14)
16 STATE X2 (12,13,14/11)
17 STOCK# X10 (11,12,14,18/)
18 STREET-ADD X26 (12,13,14/11)
19 VENDOR X16 (12,13/)
20 STORE# 8J2 (11,12/14)
21 UNIT-COST P8 (/12) <---- data item reordered
22 TAX J2 (14/)
23 TOTAL J2 (11,14/)
24 ZIP X6 (12,13,14/11)