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 Choose Database on the Database menu.

   The ERwin Data Modeler - Target Server dialog opens.

2. Make your selections using the following options, then click OK.

   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.

   Note: This option is not available for FoxPro or SAS.

   • Trigger Directory

     Opens the Default Trigger Directories/Prefixes dialog so you can specify the directory in which you want to generate triggers during schema generation for the Progress target server.

   • Trigger Delimiter

     Lets you specify the delimiter for trigger code that you want to appear in the schema DDL for DB2/UDB 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 or Sybase IQ 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, Sybase IQ, SQL Server, Oracle, and FoxPro.

     WITH NULL - This option is only available for Ingres.

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