ALLBASE/SQL Reference Manual (36216-90216)

646 AppendixC

Sample DBEnvironment

ManufDB.SupplyBatches Table

isql=> select * from manufdb.supplybatches;

select * from manufdb.supplybatches;

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

VENDPARTNUMBER |BATCHSTAMP |MINPASSRATE

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

7310 |1984-06-19 08:45:33.123 | 0.99

8113 |1984-06-14 11:13:15.437 | 0.93

790805 |1984-07-02 14:54:07.984 | 0.95

70250 |1984-07-22 09:06:23.319 | 0.97

9040 |1984-07-09 16:07:17.394 | 0.94

9050 |1984-07-13 09:25:53.183 | 0.97

29201 |1984-07-15 15:32:03.529 | 0.98

13350 |1984-07-25 10:15:58.159 | 0.97

549335 |1984-08-19 08:45:33.123 | 0.98

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

Number of rows selected is 10

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