For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.
Property | Description |
---|---|
Name | Specifies a name for the object. |
Label | Specifies a label that is displayed in visual diagrams. |
Transform As | Use this field to specify how to transform the XML column when you transform the physical data model to a logical data model. This field is enabled only when the data type that you select in the Type tab is an XML data type. |
Property | Description |
---|---|
Domain | Specifies a domain data type for the column. You must associate a domain model with the data design project or define domains in a physical model to see domain data types in this list. |
Data type | Specifies a base data type for the column. |
Precision | Specifies a precision for the column. Only available if the data type requires a precision specification. |
Length | Specifies a length for the column. Only available if the data type requires a length specification. |
Scale | Specifies a scale for the column. Only available if the data type requires a scale specification. |
Allocate | For DB2 for i5/OS™ columns only: Specifies for VARCHAR, VARGRAPHIC, VARBINARY, XML, and LOB types the space to be reserved for the column in each row. |
Expression | Specifies an expression for the column. Available only if Generated is selected. |
Default value | Specifies a default value for the column. Available only if Generated is not selected. |
Default constraint name | Specifies a name for the constraint. Available only if a default value is already specified. |
Primary Key | Designates a column as a primary key column. |
Not Null | Specifies that the column cannot contain null values. |
Generated | Designates that values for this column are generated by the DB2 database system. |
Start value | Specifies a value for the START WITH clause. Available only if Generated is not selected. |
Increment | Specifies a value for the INCREMENT BY clause. Available only if Generated is not selected. |
Minimum | Specifies a value for the MINVALUE clause for an identity column. Available only if Generated is not selected. |
Maximum | Specifies a value for the MAXVALUE clause for an identity column. Available only if Generated is not selected. |
Cycle | Specifies whether an identity column continues to generate values after reaching either its maximum or minimum value. Specifies the CYCLE option. Available only if Generated is not selected. |
Cache | For an identity column, specifies how many values of the identity sequence are to be pre-allocated and kept in memory. When values are generated for the identity column, pre-allocating and storing values in the cache reduces synchronous I/O to the log. |
Hidden | For DB2 columns only: Indicates the column is included in implicit references to the table in SQL statements. |
Row change timestamp | For DB2 columns only: Specifies that the column is a timestamp and the values will be generated by the database manager. |
FieldProc | For DB2 for i5/OS only: Specify a field procedure for the column. |
FieldProc Parameter | For DB2 for i5/OS only: Specify the parameters list for the field procedure. |
The fields are enabled only when the data type selected in the Type tab is a XML data type.