To use the demo database to test your installation, create iqdemo.db and load the sample data. Scripts that create and load the demo database are located in the $IQDIR15/demo directory.
To create the demo database, open a terminal, change to the $IQDIR15/demo directory, and run:
mkiqdemo.sh
To start the demo database, run:
start_iq @iqdemo.cfg iqdemo.db
15.x demo database table names are different than those in the 12.x versions of the software. Table 4-1 includes current and former iqdemo table names. If you are upgrading from an earlier version of Sybase IQ, use this table to update the table names or permissions in your scripts or applications.
12.7 name |
15.x name |
15.x owner |
|---|---|---|
contact |
Contacts |
GROUPO |
customer |
Customers |
GROUPO |
department |
Departments |
GROUPO |
employee |
Employees |
GROUPO |
fin_code |
FinancialCodes |
GROUPO |
fin_data |
FinancialData |
GROUPO |
product |
Products |
GROUPO |
sales_order_items |
SalesOrderItems |
GROUPO |
sales_order |
SalesOrders |
GROUPO |
emp1 |
emp1 |
DBA |
iq_dummy |
iq_dummy |
DBA |
sale |
sale |
DBA |
SYSOPTIONDEFAULTS |
DBA |
To create the older asiqdemo version
of the demo database, change to $IQDIR15/demo,
and run: mkiqdemo.sh -old. For additional options,
use the mkiqdemo.sh -help command.
