ALLBASE/SQL Reference Manual (36216-90216)

654 AppendixC
Sample DBEnvironment
PurchDB.Parts Table
PurchDB.Parts Table
select * from purchdb.parts;
----------------+------------------------------+--------------
PARTNUMBER |PARTNAME |SALESPRICE
----------------+------------------------------+--------------
1123-P-01 |Central Processor | 500.00
1133-P-01 |Communication Processor | 200.00
1143-P-01 |Video Processor | 180.00
1153-P-01 |Graphics Processor | 220.00
1223-MU-01 |Cache Memory Unit | 80.00
1233-MU-01 |Main Memory Unit | 300.00
1243-MU-01 |Extended Memory Unit | 100.00
1323-D-01 |Floppy Diskette Drive | 200.00
1333-D-01 |Slimline Diskette Drive | 200.00
1343-D-01 |Winchester Drive | 2000.00
1353-D-01 |Standard Drive | 1300.00
1423-M-01 |Video Monitor | 340.00
1433-M-01 |Graphics Monitor | 650.00
1523-K-01 |Keyboard | 200.00
1623-TD-01 |Tape Drive | 1800.00
1723-AD-01 |Graphics Monitor Adapter | 240.00
1733-AD-01 |Monochrome Displ/Prt Adapter | 250.00
1823-PT-01 |Graphics Printer | 450.00
1833-PT-01 |Color Printer | 1995.00
1923-PA-01 |Printer Adapter | 75.00
1933-FD-01 |Fixed Disc Adapter | 590.00
1943-FD-01 |Plotter Adapter | 600.00
---------------------------------------------------------------------
Number of rows selected is 22
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>