User-Defined Routines for the Object-Relational Database Model

The superstores_demo database does not replace the stores_demo database. Both databases are available. The superstores_demo database schema is not backward compatible with stores_demo. In many cases, you cannot use test queries developed for stores_demo against the tables of superstores_demo because the tables differ.

No SQL command files are associated specifically with superstores_demo. However, there are user-defined routines that you can use with the screens described in The Query-language Option.

The superstores_demo database includes examples of the following new features:

• Collection types: SET, LIST
• Named row types: location_t, loc_us_t, loc_non_us_t
• Unnamed row types
• Type and table inheritance
• Built-in data types: BOOLEAN, SERIAL8, INT8
• Distinct data type: percent
• Smart large objects: BLOB and CLOB

The superstores_demo database has row types and tables to support the following table-inheritance hierarchies:

• customer/retail_customer
• customer/whlsale_customer
• location/location_us
• location/location_non_us

For a complete description of the superstores_demo tables and inheritance hierarchies, see the IBM Informix: Guide to SQL Reference. For more information on user-defined routines, see IBM Informix: User-Defined Routines and Data Types Developer's Guide.