Use this page to specify information about the source table.
To specify a schema with a name that is different than this user ID, use one of these methods:
Click the down arrow to display a list of existing schemas and select one.
Type the name of the schema that you want. The schema can be an existing one or, if you have IMPLICIT_SCHEMA authority, you can name a new schema. This name:
Can contain up to 128 characters.
Cannot be one of the following reserved schema names: SYSCAT, SYSFUN, SYSIBM, or SYSSTAT.
Can be an ordinary or delimited identifier.
You do not need to specify a table space. If you created a table space from your user ID, the table will be created in that table space. If no table space is found, the table will be created in the default table space, USERSPACE1.
If you plan to specify a specific index table space or long data table space, you must specify a regular DMS table space other than the default table space.
This field is available only if you specified a table space other than the default in the Table space field. If you do not specify an index table space, the indexes will be created in the same table space as the table.
Use this page to add, change, or remove column definitions for a table.
You can select a new column to change any field, remove the new column from the table, or reorder the new column among the other new columns.
Specify the data type of the column that you are adding. To specify the data type, click the down arrow to display a list of data types and select one.
The data type can be:
CHARACTER
NUMERIC
DECIMAL
INTEGER
SMALLINT
FLOAT
DOUBLE
REAL
DATE
TIME
TIMESTAMP
VARCHAR
LONG VARCHAR
GRAPHIC
VARGRAPHIC
LONG VARGRAPHIC
BLOB
CLOB
DBCLOB
Specify the length (byte count) of the columns based on the specified data type:
CHARACTER: The length of the fixed-length character string, which can range from 1 to 254. The default is 10.
VARCHAR: The maximum length of the varying-length character string, which can range from 1 to 4000. The default is 10.
GRAPHIC: The length of the fixed-length graphic string, which can range from 1 to 127. The default is 0.
VARGRAPHIC: The maximum length of the varying-length graphic string, which can range from 1 to 2000. The default is 0.
BLOB: The maximum length of the BLOB string, which can range from 1 to 2 147 483 647. The default is 0.
CLOB: The maximum length of the CLOB string, which can range from 1 to 2 147 483 647. The default is 0.
DBCLOB: The maximum length of the DBCLOB string, which can range from 1 to 1 073 741 823 double-byte characters. The default is 0.
Use this field to specify the precision of a DECIMAL or NUMERIC number. The precision is the total number of digits, which can range from 1 to 31. If you do not specify the precision, a default value of 5 is used.
This field is available only if you specified DECIMAL or NUMERIC in the Data type field.
Use this field to specify the scale of a DECIMAL or NUMERIC number. The scale is the number of digits to the right of the decimal point, which can range from 0 to the precision of the number. If you do not specify the scale, a default value of 0 is used.
This field is available only if you specified DECIMAL or NUMERIC in the Data type field.
Select to allow the column to contain null values. The default value for the column is either the null value or the value specified in the Default field.
If the column will be a warehouse primary key column, it cannot be nullable.
Select if the column will contain text. Enabled for the following data types:
CHARACTER
VARCHAR
LONG VARCHAR
GRAPHIC
VARGRAPHIC
LONG VARGRAPHIC
Type a description for the column. The description can have a maximum
length of 200 characters.
This page is displayed for DB2 tables only. Use this page to:
Manually define the warehouse primary key for a source table to the Data Warehouse Center.
View the warehouse primary key definition that was imported from DB2.
You can define up to 16 columns to be warehouse primary key columns. The sum of their length attributes must not exceed 255 bytes.
You cannot define columns of data type LOB, LONG VARCHAR, or LONG VARGRAPHIC to be warehouse primary key columns.
Use this field to view the list of warehouse primary key columns or to select a column or columns to remove from the list with the < push button.
To add a column to this list, select a column from the Available columns list, and then click >.
This page is displayed for DB2 tables only. Use this page to:
Manually define the foreign keys for a source table to the Data Warehouse Center.
View foreign key definitions that were imported from DB2.
Before you begin, you must know the names of the warehouse primary keys and tables to which the warehouse foreign keys correspond. Warehouse foreign keys are used in a data warehouse to document the relationships between facts and dimensions. These relationships should be used in the warehouse for population and for usage, either by query tools or OLAP cubes.
