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.
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 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 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.
