Generating DDL Scripts for the RAPCache Database

The RAPCache database is an Adaptive Server Enterprise (ASE) database. The data model for RAPCache is RAPCache.pdm , located in the $RAP/RAPCache/datamodel/MarketData directory.

• Changing the Default Database User
  You may want to 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 Custom DDL Scripts
  Execute the DDL script in Interactive SQL and create database objects in the RAPCache database. These instructions apply to UNIX and Linux platforms.
• Modifying DDL Scripts
  The standard RAPCache database DDL script that ships with Sybase RAP includes configuration statements not found in DDL generated directly from the data model. If you generate DDL from the data model, you must add the missing statements.

---

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