Generating DDL Scripts for the RAPStore Database

Follow these instructions to generate DDL for RAPStore, which is a Sybase IQ database. The data model for RAPStore is RAPStore.pdm, which is located in the $RAP/RAPStore/datamodel/MarketData folder.

• Changing the Default Database User
  Overwrite the default database owner with a name specific to your environment.
• Generating DDL Scripts
  Generate DDL directly from the data model. PowerDesigner saves the results in a SQL script that you use to generate the tables and other objects in the target database.
• Executing DDL Scripts
  Execute the DDL script in Interactive SQL and create database objects in the RAPStore database.

---

Created March 26, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com