Creating an SAP® Sybase® IQ
database is part of a larger setup process that begins with installation and ends when your
database is available to users.
- Install and configure SAP Sybase IQ.
Install both the client and server environments. See the Installation and Configuration Guide.
- Start and connect to a database server.
Enable database control and open a communication channel to
the database. Use the start_iq utility,
SAP Control Center, the Windows Start
menu, or a configuration file.
- Create a database.
Create both the IQ store and the catalog store. You may use SAP Control Center, the SQL statement CREATE DATABASE, or the iqinit utility.
- Create the tables in your database.
Use the CREATE TABLE statement or the
SAP Control Center Create Table
wizard.
- Create indexes for the tables.
Use the CREATE INDEX statement or the
SAP Control Center Create Index wizard.
You can also create certain indexes automatically when you create your
tables.
- 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 Administration: Load Managementt.