ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 657
Sample DBEnvironment
PurchDB.SupplyPrice Table
1623-TD-01 | 9011|55050
1623-TD-01 | 9015|9080
1723-AD-01 | 9004|10875
1723-AD-01 | 9011|59050
1723-AD-01 | 9012|70100
1723-AD-01 | 9015|9090
1733-AD-01 | 9004|10775
1733-AD-01 | 9011|57050
1733-AD-01 | 9012|70450
1823-PT-01 | 9002|1533
1823-PT-01 | 9008|790115
1823-PT-01 | 9013|9105
1833-PT-01 | 9012|70500
1833-PT-01 | 9013|9135
1923-PA-01 | 9002|8113
1923-PA-01 | 9008|790805
1923-PA-01 | 9012|71755
1923-PA-01 | 9014|15550
1933-FD-01 | 9001|7310
1933-FD-01 | 9003|93715
1933-FD-01 | 9007|35701
1933-FD-01 | 9009|99201
1933-FD-01 | 9014|16530
1943-FD-01 | 9007|37502
---------------------------------------------------------------------
Number of rows selected is 69
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>
isql=> select unitprice,deliverydays,discountqty from purchdb.supplyp
------------------+------------+-----------
UNITPRICE |DELIVERYDAYS|DISCOUNTQTY
------------------+------------+-----------
450.00| 30| 1
475.00| 15| 5
550.00| 15| 3
475.00| 30| 5
500.00| 20| 5
525.00| 15| 2
180.00| 30| 6
200.00| 15| 10
220.00| 15| 12
195.00| 20| 15
180.00| 30| 15
185.00| 15| 12
175.00| 30| 9
180.00| 20| 10
210.00| 30| 10
220.00| 15| 8
200.00| 15| 5
75.00| 15| 3
85.00| 30| 5
80.00| 15| 5
285.00| 15| 4