Chapter 4: Generating DDL Scripts

Executing the script

At this point, you can execute the DDL script in Interactive SQL and create database objects in the RAP repository Sybase IQ database.

Click Start, point to Programs | Sybase | Adaptive Server IQ 12.6 | Interactive SQL Java.

If the Sybase IQ server is not running, start the server as described in the section “Starting the RAP repository database” in Chapter 2 “Repository Database Setup” of the Risk Analytics Platform Installation and Configuration Guide.
Use the ODBC DSN you created to connect to the RAP repository IQ database.
Click File, choose Open.
On the Open dialog, using the Look in drop-down menu, go to the directory where the DDL script was saved after you generated the script from the RAP_IQ.pdm model. Select the .sql script file and open it.
Click the Execute SQL statement icon on the toolbar to execute the script and create the database tables and other database objects.

Start the Sybase IQ database server, if the server is not already running. To do this, change to the directory that contains the database files and use the following command format:
```
start_asiq -n server_name @config_file.cfg database_name.db
```
Be sure to 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 the following command at the operating system prompt to start Interactive SQL Java:
```
dbisql
```
Enter the correct User ID, Password, and server information in the dbisql Connect dialog box.
Open the generated DDL script for IQ and click the Execute SQL statement button on the Interactive SQL toolbar to execute the script.