For more information about DB2 UDB for z/OS syntax, see the reference information that is included with the product. There may be differences between DB2 syntax and the syntax for other vendors.
Property | Description |
---|---|
Name | Type a name. |
Label | Type a label. This label is displayed in visual diagrams. |
Schema | Shows the relational schema under which this object was created. |
Audit | Select an option for the AUDIT clause. You can select ALL, CHANGES, or NONE. |
Data capture | Select an option for the DATA CAPTURE clause. You can select CHANGES or NONE. |
Edit procedure | Type a program name for the EDITPROC clause. |
Encoding | Select an encoding scheme. You can select EBCDIC, ASCII, UNICODE, or NONE. |
Valid procedure | Type a program name for the VALIDPROC clause. |
Property | Description |
---|---|
Primary Key | Select to designate a column as a primary key column. |
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. |
Data type | Select a base data type for the column. |
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. |
Not Null | Select to prevent the column from containing null values. |
Generated | Select to designate that values for this column are generated by DB2 UDB. |
Default Value - Generate Expression | Specify a default value or expression for the column. If you select the Generated check box for this column, this field designates an expression. If the you do not select the Generated check box for this column, this field designates a default value. You can type a value or expression or select a value or expression from the list. |
Property | Description |
---|---|
Name | Shows the name of the column. This property cannot be edited. |
Data type | Shows the data type of the column. This property cannot be edited. |
Ordering type | Select an option for ordering the entries by column. You can select ASC (ASCENDING) or DESC (DESCENDING). |
Nulls last | Select to use the NULLS LAST clause. |
Ending limit | Click the ellipsis [...] button in this cell to open a window where you can specify an ending limit for each partition. |