ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 651
Sample DBEnvironment
PurchDB.OrderItems Table
30521| 3|790805
30522| 1|13350
---------------------------------------------------------------------
Number of rows selected is 47
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>
select purchaseprice,orderqty,itemduedate,receivedqty from
purchdb.orderitems;
--------------+--------+-----------+-----------
PURCHASEPRICE |ORDERQTY|ITEMDUEDATE|RECEIVEDQTY
--------------+--------+-----------+-----------
2000.00| 5|19840621 | 3
565.00| 10|19840621 | 10
450.00| 5|19840701 | 5
180.00| 5|19840701 | 2
210.00| 5|19840701 | 5
70.00| 10|19840616 | 8
435.00| 3|19840705 | 2
70.00| 5|19840701 | 5
345.00| 3|19840701 | 3
195.00| 5|19840701 | 5
180.00| 5|19840715 | 5
195.00| 5|19840701 | 4
195.00| 5|19840701 | 4
475.00| 3|19840715 | 2
175.00| 3|19840715 | 3
450.00| 5|19840701 | 4
80.00| 10|19840705 | 10
335.00| 3|19840710 | 3
650.00| 5|19840710 | 5
2000.00| 5|19840715 | 3
565.00| 10|19840715 | 7
525.00| 3|19840710 | 3
200.00| 10|19840726 | 8
205.00| 10|19840726 | 10
1985.00| 3|19840715 | 3
70.00| 10|19840715 | 9
190.00| 15|19840710 | 14
200.00| 10|19840715 | 10
1310.00| 5|19840715 | 5
1650.00| 3|19840726 | 3
240.00| 5|19840715 | 5
200.00| 10|19840711 | 9
220.00| 5|19840711 | 4
645.00| 5|19840711 | 3
195.00| 10|19840716 | 10
180.00| 10|19840716 | 10
210.00| 5|19840716 | 4
590.00| 5|19840711 | 5
335.00| 5|19840711 | 5
650.00| 5|19840711 | 5
95.00| 10|19840716 | 9
450.00| 3|19840711 | 3