ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 653

Sample DBEnvironment

PurchDB.Orders Table

isql=> select * from purchdb.orders;

-----------+------------+---------

ORDERNUMBER|VENDORNUMBER|ORDERDATE

-----------+------------+---------

30507| 9001|19840601

30508| 9002|19840601

30509| 9002|19840615

30510| 9006|19840615

30511| 9004|19840615

30512| 9008|19840615

30513| 9010|19840626

30514| 9001|19840626

30515| 9012|19840626

30516| 9015|19840626

30517| 9003|19840627

30518| 9009|19840627

30519| 9010|19840627

30520| 9013|19840627

30521| 9008|19840627

30522| 9014|19840627

30523| 9014|19840628

---------------------------------------------------------------------

Number of rows selected is 17

U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>