Column properties (DB2)

Use the Properties view to modify the properties of a DB2® column.

For more information about DB2 syntax, see the reference information that is included with each product. There may be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Type page
Property Description
Domain Select a domain data type for the column. You must associate a domain model with the data design project or define domains in your physical model to see domain data types in this list.
Generated column Select to designate that values for this column are generated by DB2. The properties on this page change depending on whether you specify this option.
Data type Select a base data type for the column.
Precision Specify a precision for the column. Only available if you select a domain or base data type that requires a precision specification.
Length Specify a length for the column. Only available if you select a domain or base data type that requires a length specification.
Scale Specify a scale for the column. Only available if you select a domain or base data type that requires a scale specification.
Expression Specify an expression for the column. Available only if Generated Column is selected.
Default value Specify a default value for the column. Available only if Generated Column is not selected.
Primary Key Select to designate a column as a primary key column.
Not Null Select to prevent the column from containing null values.
Identity Select to designate the column as an identity column. If you select Generated Column, the column is generated as an identity column. If you do not select Generated Column, additional fields are available on this page so that you can specify additional identity column attributes.
Start value Type a value for the START WITH clause. Available only if Identity is selected and Generated Column is not selected.
Increment Type a value for the INCREMENT BY clause. Available only if Identity is selected and Generated Column is not selected.
Minimum Type a value for the MINVALUE clause. Available only if Identity is selected and Generated Column is not selected.
Maximum Type a value for the MAXVALUE clause. Available only if Identity is selected and Generated Column is not selected.
Cycle Select to specify the CYCLE option. Available only if Identity is selected and Generated Column is not selected.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback