To specify a schema with a name that is different than this 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, it can be a new one. 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.
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 view, 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 one of:
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
Length of the fixed-length character string, which can range from 1 to 254. The default is 10.
VARCHAR
Maximum length of the varying-length character string, which can range from 1 to 4000. The default is 10.
GRAPHIC
Length of the fixed-length graphic string, which can range from 1 to 127. The default is 0.
VARGRAPHIC
Maximum length of the varying-length graphic string, which can range from 1 to 2000. The default is 0.
BLOB
Maximum length of the BLOB string, which can range from 1 to 2 147 483 647. The default is 0.
CLOB
Maximum length of the CLOB string, which can range from 1 to 2 147 483 647. The default is 0.
DBCLOB
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
Optional: Type a description for the column. The description can have
a maximum length of 200 characters.
Use this page to:
Manually define the warehouse primary key for a view to the Data Warehouse Center.
View the warehouse primary key definition that was imported.
You can define up to 16 columns as 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 list to view the warehouse primary key columns for the view or to select a column or columns to remove from the list with the < button.
To add a column to this list, select a column from the Available columns list, and then click >.
Use this page to:
Manually define the warehouse foreign keys for a view to the Data Warehouse Center.
View warehouse foreign key definitions that were imported.
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 warehouse to document the relationships between facts and dimensions. These relationships are used in the warehouse for population and for usage, either by query tools or OLAP cubes.
