ALLBASE/SQL Reference Manual (36216-90216)

660 AppendixC
Sample DBEnvironment
PurchDB.Vendors Table
Number of rows selected is 18
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>
select vendorcity,vendorstate,vendorzipcode from purchdb.vendors;
--------------------+-----------+-------------
VENDORCITY |VENDORSTATE|VENDORZIPCODE
--------------------+-----------+-------------
Concord |AL |35567
Littleton |CO |80123
Santa Clara |CA |95033
Puget Sound |WA |96122
Atlantic City |NJ |10807
Pebble Beach |CA |95012
Snake River |ID |74503
Bethesda |MD |20068
San Jose |CA |95110
Crabtree |MA |02135
Braintree |MA |02088
City of Industry |CA |92108
Oceanside |CA |92078
Phoenix |AR |60987
Cupertino |CA |95035
Bakersfield |CA |93662
San Jose |CA |95130
Lac du Choc |MN |32134
---------------------------------------------------------------------
Number of rows selected is 18
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>
select vendorremarks from purchdb.vendors;
------------------------------------------------------------
VENDORREMARKS
------------------------------------------------------------
Slow shipping
Discount rate 5%
Slow shipping
Discount rate 5.5%
Discount rate 5%, slow shipping
Poor service
Discount rate 6%, purchase over $10,000
No discount rate, fast shipping
Often out of stock, fast shipping
Discount rate 5.5%
Fast shipping, 5% Discount
Discount rate 6% for order over $15000
Discount rate 10%, very slow shipping
Discount rate 5%, fast shipping
Discount 6%, fast shipping
---------------------------------------------------------------------
Number of rows selected is 18
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>