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. This label is displayed in visual diagrams. |
Schema | Shows the relational schema under which this object was created. |
DB2® for z/OS® only: Audit | Specifies an option for the AUDIT clause. You can select ALL, CHANGES, or NONE. Identifies the types of access to this table that causes auditing to be performed. |
DB2 for z/OS only: Data capture | Specifies an option for the DATA CAPTURE clause.
You can select CHANGES or NONE. Specifies whether the logging of the
following actions on the table is augmented by additional information:
|
DB2 for z/OS only: Edit procedure | Specifies a program name for the EDITPROC clause. Designates this program name as the edit routine for the table. The edit routine, which must be provided by the current server's site, is invoked during the execution of an SQL data change statement or LOAD and all row retrieval operations on the table. |
DB2 for z/OS only: Encoding | Specifies an encoding scheme. You can select EBCDIC, ASCII, UNICODE, or NONE. This setting specifies which CCSIDs are used to encode the data. |
DB2 for z/OS only: Valid procedure | Specifies a program name for the VALIDPROC clause. Designates this program name as the validation exit routine for the table. |
DB2 for z/OS only: Volatile | Select this option to specify that index access should be used on this table whenever possible for SQL operations. However, be aware that list prefetch and certain other optimization techniques are disabled when VOLATILE is used. If you do not select this option, SQL access to this table is based on the current statistics. |
Property | Description |
---|---|
DB2 for Linux, UNIX, and Windows, DB2 for iSeries®, or Oracle only: Maintained By | Select an option for the PARTITIONING KEY clause. You can select HASHING (USING HASHING) or TABLE_REPLICATED (REPLICATED) for DB2 databases, or HASH, RANGE, or LIST for Oracle. |
Name or Column | Specifies the name of the column. |
Data type | Specifies the data type of the column. |
DB2 for z/OS only: Ordering type | Specifies an option for ordering the entries by column. You can select ASC (ASCENDING) or DESC (DESCENDING). |
DB2 for z/OS only: Nulls last | Specifies using the NULLS LAST clause. Specifies that null values are treated as positive infinity for purposes of comparison. |
DB2 for z/OS only: Ending limit | Specifies an ending limit for each partition. |
For HASH or USING HASHING partitions: You must specify a partition name, and if you select a LOB table space you must select at least one LOB column.
For LIST or RANGE partitions (Oracle only): You must specify a partition name, column values, and if you select a LOB table space you must select at least one LOB column.
Property | Description |
---|---|
DB2 for Linux, UNIX, and Windows only: Column | For a partition expression, identifies a column of the data partitioning key. |
DB2 for Linux, UNIX, and Windows only: Nulls | For a partition expression, indicates how NULL values compare (high or low). |
Partition Name | Specifies the name of the partition. |
DB2 for Linux, UNIX, and Windows only: Starting value | For a RANGE partition, specifies the low end of the range. |
DB2 for Linux, UNIX, and Windows only: Ending value | For a RANGE partition, specifies the high end of the range. |
DB2 for Linux, UNIX, and Windows only: Inclusiveness | For a RANGE partition, indicates that the specified range values are to be included in the data partition, or indicates that the specified constant values are to be excluded from the data partition. |
DB2 for Linux, UNIX, and Windows only: Regular table space | Specifies the regular table space where the partition will be stored. The named table space must have the same page size, be in the same database partition group, and manage space in the same way as the other table spaces of the partitioned table (SQLSTATE 42838); it must be a table space on which the authorization ID of the statement holds the USE privilege. If this clause is not specified, a table space is automatically assigned to the partition. |
Oracle only: Values | Specifies the column values for the partition. |
Oracle only: Table Space | Specifies the table space under which this partition was created. |
Oracle only: LOB Columns | Specifies LOB columns that are included in the partition. |
Oracle only: LOB Table Spaces | Specifies LOB table spaces under which this partition was created. |
Property | Description |
---|---|
Regular | Specifies a table space for the table. |
Index | Specifies a table space in which any indexes on the table will be created. |
LOB | Specifies a table space in which the values of any long columns will be stored. |
Specifies a dimension for each column or group of columns used to cluster the table data. Use the toolbar buttons to add, remove, reorder, or edit columns in the dimension.
Property | Description |
---|---|
Primary Key | Designates a column as a primary key column. |
Domain | Specifies 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 | Specifies a base data type for the column. |
Length | Specifies a length for the column. Only available for data types that requires a length specification. |
Scale | Specify a scale for the column. Only available for data types that requires a scale specification. |
Not Null | Specifies that the column cannot contain null values. |
Generated | Specifies that values for this column are generated by the DB2 database system. |
Default Value - Generate Expression | Specifies a default value or expression for the column. If the Generated check box is selected for this column, this field designates an expression. If the Generated check box is not selected for this column, this field designates a default value. |
Property | Description |
---|---|
Initial number of rows | In edit mode, enter the initial number of rows for this table. |
Row growth per month | In edit mode, enter the estimated increased number of rows that you expect each month for this table. |
Maximum number of rows | In edit mode, enter the maximum number of rows for this table. |
Size estimation (Projected in month) | In edit mode, enter the month for which you
want to calculate size and the estimations in the table are updated.
|