Creating Models › Creating a Physical Model › Columns › Defining Table Column Properties for Target Databases

Defining Table Column Properties for Target Databases

In a physical model, the <database> tab in the Table Column Editor contains options for defining common table column properties such as physical data type and null option and are not database-specific.

However, more options are provided for some of the target databases that require you to define additional properties. The following target databases have additional, database-specific options for defining table column properties:

DB2 for i

DB2 LUW

DB2 zOS

Informix

Hive

Oracle

PostgreSQL

Progress

SAS

SQL Server

SAP IQ

Teradata

More information:

Define Basic Table Column Properties