Executing DDL Scripts for the SAP Sybase IQ Database

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

Prerequisites

Start the SAP Sybase IQ database server if it is not running.

Task

In a command prompt, change to the directory that contains the database files and 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.
Enter dbisql.
Enter the correct user ID, password, and server information.
Open the generated DDL script for SAP Sybase IQ and click Execute SQL Statement on the toolbar.