Creating an IQ database is part of a larger setup process that begins with installation and ends when your database is available to users. This section summarizes the steps in setting up an IQ database and the objects in it.
Install and configure Sybase IQ.
This step installs the client and server environment and the iqdemo database. See the Installation and Configuration Guide for your platform for details.
Create an IQ database.
This step creates both the IQ store and the catalog store. You may use Sybase Central, the SQL statement CREATE DATABASE, or the iqinit utility.
For Sybase Central (the easiest way to use multiplex capability), see “Using Sybase Central to create an IQ database”.
For CREATE DATABASE instructions, see “Creating a database with SQL”.
For iqinit, see “Initialization utility (iqinit)” in Chapter 5, “Working with Database Objects,” in the Utility Guide.
Create the tables in your IQ database.
Use the CREATE TABLE statement or the Sybase Central Create Table wizard. See “Working with tables”
Create indexes for the tables.
Use the CREATE INDEX statement or the Sybase Central Create Index wizard. You can also create certain indexes automatically when you create your tables. See Chapter 6, “Using Sybase IQ Indexes.”
Load data into the tables.
Use the LOAD TABLE statement to bulk load data from files, or use the INSERT statement to extract rows of data from an existing database. See Chapter 7, “Moving Data In and Out of Databases.”.
Setting up an IQ database