http://developer.mimer.com

The MIMER_STORE Schema Revisited

---

A quick return to the base schema to include two PSM routines that are outside the scope of an introduction to SQL.

PSM Routines

PSM routine name	Description
ORDER_ITEM	Procedure to associate an order for a quantity of a particular item against an order identifier.
BARCODE	Result set procedure that returns the book or music details for a given EAN. The intention would be to use this with a POS barcode reader.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se