DDL Script Generation

The data models for the SAP Sybase IQ, SAP HANA, and ASE databases target different databases; however, they share an almost identical structure. Modify data models by creating additional tables or columns to suit your business environment.

The corresponding adapter (IQ, HANA, ASE) schema must match the SAP Sybase IQ, HANA, and ASE database schema for all tables in which data is inserted. After you make changes, you can use PowerDesigner to produce a set of data definition language (DDL) statements directly from the physical data model (IQ, HANA, and ASE). PowerDesigner saves the DDL statements in a SQL script that you can run to generate the tables and other objects for the target databases.

• Generating Database Schema with PowerDesigner
  PowerDesigner includes all the resources you need to generate a set of DDL statements in SQL scripts directly from the PowerDesigner data models. Run these scripts to generate a schema for your SAP Sybase IQ, SAP HANA, and ASE databases.
• Generating DDL Scripts
  Generate DDL scripts directly from the SAP Sybase IQ, SAP HANA, or SAP Sybase ASE data model. PowerDesigner saves the results in a SQL script that you can use to generate the tables and other objects in the target database.
• Executing DDL Scripts for the SAP Sybase IQ Database
  Execute the DDL script in Interactive SQL and create database objects in the SAP Sybase IQ database.
• Executing DDL Scripts for the SAP HANA Database
  Execute the DDL script using hdbsql and create database objects in the SAP HANA database.
• Executing DDL Scripts for the ASE Database
  Execute the DDL script in Interactive SQL and create database objects in the ASE database.