Demo database

Sybase IQ 15.1 includes a demo database. In the $IQDIR15/demo directory, you will see the script mkiqdemo.sh. This script creates the demo database by modifying, then running the script mkiqdemo.sql, which loads sample data from the adata subdirectory.

The sample data supports an imaginary sporting goods company. The demo database has been updated for the 15.x release. If you are upgrading from a previous edition, see “Table names” for demo database table names. The table includes the former names and new names of sample tables so that you can update scripts or applications.

StepsCreating the demo database

The file $IQDIR15/demo/mkiqdemo.sql contains SQL statements that create the database and $IQDIR15/demo/adata contains its data.

  1. In the directory $IQDIR15/demo, run mkiqdemo.sh.

NoteFor customers who prefer the older asiqdemo database, you can still create that database by passing in the flag -old to the mkiqdemo.sh script. Use mkiqdemo.sh -help to display additional options.

Table names

If you are upgrading from a previous edition, see the following table for a list of current table names in the demo database. Use this table to update scripts or applications.

Table 4-1: demo database table names

12.7 name

15.1 name

15.1 owner

contact

Contacts

GROUPO

customer

Customers

GROUPO

department

Departments

GROUPO

emp1

emp1

DBA

employee

Employees

GROUPO

fin_code

FinancialCodes

GROUPO

fin_data

FinancialData

GROUPO

iq_dummy

iq_dummy

DBA

product

Products

GROUPO

sale

sale

DBA

sales_order_items

SalesOrderItems

GROUPO

sales_order

SalesOrders

GROUPO

SYSOPTIONDEFAULTS

DBA

NoteMegaphone Telco is not included with Sybase IQ 15.1.