Before you load the sample data, use PowerDesigner to produce a set of data definition language (DDL) statements from the data model. PowerDesigner saves the DDL in a SQL script you can run to generate the tables and other objects for the target Sybase IQ database.
Generating the DDL involves the following steps:
Opening the model in PowerDesigner
Changing the name of the default database user (RAP_USER) to the IQ user
Generating the script that creates a schema for the new IQ database
Logging into the sample database and running the script
Note
You need to install Sybase PowerDesigner 11.0 before you create
the DDL for the sample database. You can also use PowerDesigner
to view and update the data model.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
