Table properties

Properties for IBM® data server table objects

For more information about table syntax, see the reference information that is included with each database product. There might be differences between the IBM data server syntax and the syntax for other vendors.

General page
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:
  • SQL data change operations
  • Adding columns (using the ADD COLUMN clause of the ALTER TABLE statement)
  • Changing columns (using the ALTER COLUMN clause of the ALTER TABLE statement)
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.
Columns page
In edit mode, use the grid and the toolbar buttons on this page to add, delete, change the order, and modify properties for columns.
  • Click the New toolbar button to add a new column to the bottom of the grid.
  • Click the Delete toolbar button to delete a column.
  • Select a column in the grid and click Move Column Up or Move Column Down to change the order of columns.
  • Use the grid to modify the properties of a column. Double-click a cell or click a check box in a cell to edit the cell contents. Note: You can also select a single column in a view to view or modify these and other properties in the Properties view for the column. When you view or modify properties from the Properties view for a column, additional properties are available.
    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.
DB2 for Linux®, UNIX®, and Windows®, DB2 for z/OS, or Oracle: Partition key page
In edit mode, use the grid and the toolbar buttons on this page to add, delete, change the order, and modify properties for partition key columns.
Prerequisites for setting partition key properties:
  • The table must be partitioned to a table space.
  • The table must contain at least one column.
  • The table space must be partitioned.
  • To add a new column to the partition key, click the ellipsis [...] toolbar button, select columns in the window that opens, and click OK.
  • For DB2 only: To change the order of columns, select a column in the grid and click Move Column Up or Move Column Down.
  • For DB2 only: Use the grid to modify the properties of a partition key column. Double-click a cell or click a check box in a cell to edit the cell contents.
    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.
DB2 for Linux, UNIX, and Windows or Oracle: Data partition page
In edit mode, use the toolbar buttons and the grid to add, remove, or modify data partitions.
Prerequisites for creating data partitions:
  • You must create at least one partition key.
  • To add a new data partition, click the ellipsis [...] toolbar button, specify partition details in the window that opens, and click OK.

    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.

  • For DB2 only: To change the order of columns, select a column in the grid and click Move Column Up or Move Column Down.
  • For DB2 only: Use the grid to modify the properties of a partition key column. Double-click a cell or click a check box in a cell to edit the cell contents.
    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.
DB2 for z/OS: Table spaces page
Select a table space. Click Show Properties Show Properties icon to open the Properties view for the selected object.
DB2 for Linux, UNIX, and Windows, or DB2 for iSeries: Table spaces page
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.
DB2 for Linux, UNIX, and Windows: Dimensions page

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.

Relationships page
Shows objects that are related to the object and information about the relationship. These fields cannot be edited. Select a relationship in the grid and click Show Properties Show Properties icon to open the Properties view for a related object.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.
Related information
CREATE TABLE statement syntax, Version 9.1 for z/OS
CREATE TABLE statement syntax, DB2 Version 9.1 for Linux, UNIX, and Windows
CREATE TABLE statement syntax, IBM Informix Dynamic Server v10.0

Feedback