Executing DDL Scripts

Execute the DDL script in Interactive SQL and create database objects in the Sybase IQ database.

1. If the Sybase IQ database server is not already running, start it:
   1. Change to the directory that contains the database files.
   2. Enter:

      start_iq -n server_name @config_file.cfg database_name.db.

   Use the -n switch to name the server, either in the configuration file or on the command line when you start the server.

   Note: If you specify -n server_name without a database_name, you connect to the default database on the current server. If you specify -n database_name without a server_name, you connect to the specified database on the current server.
2. Enter dbisql.
3. Enter the correct user ID, password, and server information.
4. Open the generated DDL script for Sybase IQ and click Execute SQL Statement on the toolbar.