ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 661

Sample DBEnvironment

RecDB.Clubs Table

select * from recdb.clubs;

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

CLUBNAME |CLUBPHONE|ACTIVITY

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

Energetics | 1111|aerobics

Windjammers | 2222|sailing

Downhillers | 3333|skiing

Poker Faces | 4444|cards

Spikers | 5555|volleyball

Stingers | 6666|soccer

Green Thumbs | 7777|gardening

Crescendos | 8888|music

Keys 'n Strings| 9999|music

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

Number of rows selected is 9

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