ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 659
Sample DBEnvironment
PurchDB.Vendors Table
PurchDB.Vendors Table
select vendornumber,vendorname,contactname from purchdb.vendors;
------------+------------------------------+-------------------------
VENDORNUMBER|VENDORNAME |CONTACTNAME
------------+------------------------------+-------------------------
9001|Remington Disk Drives |Debra Thomason
9002|Dove Computers |Peter B. Galvin
9003|Space Management Systems |Stacey Wolf
9004|Coupled Systems |Micki Sue Ding
9005|Underwood Inc. |Diane Oliver
9006|Pro-Litho Inc. |Karen Thomas
9007|Eve Computers |Elisa Nissman
9008|Jujitsu Microelectronics |Adam D. Gerston
9009|Latin Technology |George Warrior
9010|KellyCo Inc. |Celia Toledo
9011|Morgan Electronics |Tom Peterson
9012|Seminational Co. |Elizabeth Kramer
9013|Seaside Microelectronics |Geoff Grigsby
9014|Educated Boards Inc. |AJ White
9015|Proulx Systems Inc. |Michael Goldberg
9016|Covered Cable Co. |Phil Blank
9017|SemiTech Systems |Melissa Benson
9018|Chocolate Chips |Frederick Chung
---------------------------------------------------------------------
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 phonenumber,vendorstreet from purchdb.vendors;
---------------+------------------------------
PHONENUMBER |VENDORSTREET
---------------+------------------------------
205 555 1234 |3006 Salvo St.
303 234 5678 |123 Coyote Way
408 456 7890 |3500 Scott Ave.
206 677 2232 |1001 Island Way
609 444 3579 |2001 Boardwalk
408 765 2345 |17 Par Drive
208 999 8642 |999 West 9th Street
301 657 3579 |345 Black Boulevard
408 555 9000 |280 Park Ave.
617 333 0987 |555 Hillview Blvd.
617 666 9182 |888 Industrial Parkway
213 987 1423 |345 International Blvd.
619 355 7565 |3210 Del Mar Blvd.
602 987 0909 |4000 University Ave.
408 290 5678 |404 Nosh Ave.
|777 Twisted Trail
|428 Tech Drive
|3425 Swirl Lane
---------------------------------------------------------------------