WarehouseArchitect - User's Guide

Home

Chapter 19: Managing WarehouseArchitect Models

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 18: Creating a WAM for Sybase Adaptive Server IQ

Generating a Sybase AS IQ database

Sybase AS IQ has its own generation parameters, in addition to the standard database generation parameters.

For more information on database generation parameters see the chapter Database Creation and Modification.

Sybase AS IQ database parameters

Sybase AS IQ generation parameters concern join indexes only.

All references of join indexes are generated, whether the Generate reference checkbox in the Reference property sheet was selected or not. The Generate reference checkbox is not used by PowerDesigner for generating join indexes.

Parameter

Result of selection

Create join index

Create join indexes

Drop join index

Delete join indexes

Parameter	Result of selection
Create join index	Create join indexes
Drop join index	Delete join indexes

Generating a Sybase AS IQ database creation script

To generate a Sybase AS IQ database creation script:
1. Select Database-->Generate Database.
  The Parameters for Sybase AS IQ dialog box appears.
2. Select or clear checkboxes to define generation parameters.
3. Click the Selection tab.
4. Select or clear checkboxes to define generation parameters.
5. Click the Generate Script button.
  or
  Click the Create database button.


	Expand Search