Target Servers and the Physical Model › Select or Change the Target DBMS

Select or Change the Target DBMS

When working with a physical model, you can select or change the target DBMS for the physical schema, and define default settings to use when you generate the schema.

To select or change the target DBMS

1. Open your physical model, then click Target Database on the Actions menu.

   The ERwin Data Modeler - Target Server dialog opens.

2. Make your selections using the following options:

   Target SQL DBMS

   Lets you specify the target SQL DBMS.

   <Database> Version

   Lets you specify the software version for the DBMS you selected for the Target SQL DBMS option.

   Trigger Delimiter

   Lets you specify the delimiter for trigger code that you want to appear in the schema DDL for DB2 LUW and DB2/zOS.

   Decimal Point Indicator

   Lets you select the decimal point indicator to use when you add a column to a DB2/zOS model.

   Library

   Lets you specify the connection library (dblib or ctlib) to use to connect to your Sybase database.

   Default <Database> Datatype

   Lets you specify the default datatype to use when you add a column to the model.

   Default Non-Key Null Option or Null Option

   Specifies the default null option that you want to assign when you add a column to the model. The default null options include:

   NOT NULL - This option is available for all target databases.

   NULL - This option is only available for Sybase, My SQL, SQL Server, and Oracle.

3. Click OK.

   Your selections are saved and the CA ERwin Data Modeler - Target Server dialog closes.

More information:

Generic Open Database Connectivity (ODBC)

Specify Default Trigger Directories for Progress