Column properties

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