Column properties

Use the Properties view to modify the properties for IBM® data server column objects.

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.

General page
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.

Volumetrics page (DB2® for Linux, UNIX, and Windows or DB2 for z/OS® only)
In edit mode, enter the average data size for this column. This value is fixed for most data types that are not variable data types (for example, VARCHAR or VARGRAPHIC).
Type page
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.

XML Schema Identifiers page
Specifies the location of the XML Schema, the SQL ID and the name of the root element.

The fields are enabled only when the data type selected in the Type tab is a XML data type.

Field Statistics page
See the linked topic for more information.
Field Classification page
See the linked topic for more information.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback