Chapter 2: Repository Database Setup

Creating database objects

At this point the IQ database is ready for you to execute the DDL script and create objects in the RAP repository database.

Start Interactive SQL Java.
- On Windows, click Start, point to Programs | Sybase | Adaptive Server IQ 12.6 | Interactive SQL Java.
- On UNIX, enter this command:
```
dbisql
```
Use the ODBC DSN you created to connect to the RAP repository database.
Click File, choose Open.
On the Open dialog, using the Look in drop-down menu, go to the directory where the DDL script RAP_IQ_Tables.sql is located. This script is installed in the %SYBASE%\Model\IQ folder. Select the .sql script file and open it.
Click the Execute SQL statement icon on the toolbar to execute the script and create the RAP repository database tables and other database objects.