ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 663
Sample DBEnvironment
RecDB.Members Table
RecDB.Members Table
select * from recdb.members;
--------------------+---------------+-----------
MEMBERNAME |CLUB |MEMBERPHONE
--------------------+---------------+-----------
George Smith |Poker Faces | 1476
Darab Jones |Stingers | 2605
Annie Anderson |Green Thumbs | 1105
Annie Anderson |Stingers | 1105
Sue Peters |Green Thumbs | 7505
Al Krebbs |Poker Faces | 9615
John Ewing |Crescendos | 6925
John Ewing |Energetics | 6925
Wolfgang Ross |Keys 'n Strings| 6255
MJ Kipper |Keys 'n Strings| 3305
Jim Johnson |Spikers | 8625
Becky Gardner |Spikers | 5605
John Brown |Downhillers | 3605
Doug Griffith |Downhillers | 5915
Jorge Pablo |Stingers | 7655
Marguerite Harris |Crescendos | 1605
Bill Haley |Windjammers | 5505
Ragaa Morrow |Keys 'n Strings| 4405
Ragaa Morrow |Energetics | 4405
Miranda Wong |Windjammers | 2105
Glen Stevens |Windjammers | 8005
Peter Crane |Stingers | 1205
David Loomis |Windjammers | 9505
Sharon Means |Keys 'n Strings| 2305
Karen Manor |Downhillers | 7005
Marty Thomas |Poker Faces | 6305
Mariann Humphrey |Crescendos | 9105
Renee Ball |Crescendos | 3105
Diane Rizzo |Green Thumbs | 1715
Martha Mitchell |Energetics | 1605
Robert Klein |Energetics | 9005
Nancy Cunning |Spikers | 4605
May-Inn Kong |Energetics | 8505
Karen Walters |Keys 'n Strings| 1665
Karen Lloyd |Crescendos | 1715
Tom Thumb |Poker Faces | 2715
Stacey Valley |Stingers | 3405
---------------------------------------------------------------------
Number of rows selected is 37
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>