Producing DDL from the data model in PowerDesigner  Applying indexes to the IQ database tables

Chapter 2: Database Setup for Risk Analytics Platform

Executing the DDL script

At this point the DDL script is ready to execute and create objects in the sample database.

  1. 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 “Starting and connecting to the sample IQ database”.

  2. Use the ODBC DSN you created to connect to the sample database.

  3. Click File, choose Open.

  4. On the Open dialog, using the Look in drop-down menu, go to the directory where the DDL script was saved after you generated it from the PDM. Select the .sql script file and open it.

  5. Click the Execute SQL statement icon on the toolbar to execute the script and create the sample database tables and other database objects.




Copyright © 2005. Sybase Inc. All rights reserved. Applying indexes to the IQ database tables

View this book as PDF