In the Create Database - Options dialog, selecting the option, Create SQL script (Alt+C), Sybase Central generates a script of the CREATE DATABASE statement that creates your database once you complete the wizard. For example:
SET TEMPORARY OPTION escape_character="Off"; CREATE DATABASE 'd:\mpx\fiona.db' TRANSACTION LOG ON COLLATION 'ISO_BINENG' CASE RESPECT PAGE SIZE 4096 BLANK PADDING ON IQ PATH 'fiona.iq' IQ SIZE 10 IQ PAGE SIZE 131072 TEMPORARY PATH 'fiona.iqtmp' TEMPORARY SIZE 10 ;
Sybase Central names this script <dbname>.create.sql and places it in the database directory.
Starting the new database automatically
An IQ server is required in order to create an IQ database, although you do not need to start an IQ server explicitly before creating a database. If you have no active server, Sybase Central will start the Utility Server automatically.
Select the box to choose the server to create the database, or click Alt+A for the active IQ server or Alt+U for the Utility Server.
The Utility Server is a special server for performing administration tasks when there is no active server.
To start the new database automatically, click the checkbox or press Alt+S. The Sybase IQ Agent must be running.
If you choose to create the database but not start it, Sybase Central starts the Utility Server just long enough to create the database, then shuts it down.
On Windows systems, the Sybase IQ Agent starts automatically when
the machine is rebooted right after installation and at each subsequent
reboot. On UNIX systems, you can configure it to start automatically
also. For more information, see Chapter 2, “Running Sybase
IQ” in the Sybase IQ System Administration Guide.
Click Next.
