Submits the data in the notebook and keeps the notebook open for further input. Available only when the required fields are completed.
Cancels any unsaved changes that you made and closes this notebook.
Specifies that this column's data type is one of the DB2 built-in data types.
Specifies that this column's data type is a user-defined data type.
Type a 1- to 18-character name for the column. Do not use the same name for more than one column of the table.
If you are altering a table, this field is unavailable because you cannot change the name of an existing column.
Optional: Type the name of the field procedure exit routine for this column; for example, MYPROG. Field procedures can be specified only for short string columns that do not have a non-null default value. They are often used to change the sorting sequence of the values in the column.
If you are altering a table, this field is unavailable because you cannot change the field procedure of an existing column.
Optional: Type the parameters, separated by commas, to be passed to the field procedure for this column; for example, 4,3,7. The nth parameter corresponds to the nth parameter of the specified field procedure. The maximum length is 254 characters, including commas.
If you are altering a table, this field is unavailable because you cannot change the field procedure parameters of an existing column.
Optional: Type a 1- to 254-character (including embedded blanks) comment to document the column.
Specify the data type of the column.
If you are altering a table, this field is unavailable because you cannot change the data type of an existing column.
Specifies that the column can contain null values. Clear this check box if you don't want the column to be nullable.
If you want to use the column in a primary or unique key, it cannot be nullable. Also, ROWID columns cannot be nullable.
If you are altering a table, this field is unavailable because you cannot change this attribute of an existing column.
Type the length (byte count) of the column. The default length is 1 character. Available only if CHAR, VARCHAR, GRAPHIC, VARGRAPHIC, CLOB, BLOB, or DBCLOB is specified in the Data type field.
The maximum value allowed depends on the data type, and for LOBs, on the specified LOB units. See the online help for details.
If you are altering a table, and the column is not a VARCHAR column, this field is unavailable because you cannot change the length of an existing non-VARCHAR column.
Type an integer, that ranges from 1 to 31, for the precision (total number of digits) for a DECIMAL column. The default precision is 5. Available only if DECIMAL is specified in the Data type field.
If you are altering a table, this field is unavailable because you cannot change the precision of an existing column.
Specify a subtype for a character string column (CHAR, VARCHAR, or CLOB data type):
If you are altering a table, this field is unavailable because you cannot change the subtype of an existing column.
Optional: For a large object (LOB) column, specify the units in which the length is to be measured. Available if the Data type is CLOB, BLOB, or DBCLOB. The LOB units multiplied by the value that you specify in Length set the maximum length for the column. For example, a CLOB column with a LOB unit of K Bytes has a maximum column length of 1024 times the value specified in Length.
If you are altering a table, this field is unavailable because you cannot change the LOB units of an existing column.
Type an integer, that ranges from 0 to the number specified in Precision, for the scale (number of digits to the right of the decimal) for a DECIMAL column. The default scale is 0. Available only if DECIMAL is specified in the Data type field.
If you are altering a table, this field is unavailable because you cannot change the scale of an existing column.
Specifies that a default value be assigned to the column when no value is specified in an insert or load operation. Do not specify for a ROWID column. The available choices depend on the column's data type.
If you are altering a table, this field is unavailable because you cannot change the default of an existing column.
You cannot specify a default value for the column if you specified a field procedure for the column.
Select the type of default value to be assigned to the column when no value is specified in an insert or load operation. Available only if Default is selected.
If you are altering a table, this field is unavailable because you cannot change the default of an existing column.
The choices that are available depend on the specified column data type.
You cannot specify a default value for the column if you specified a field procedure for the column.
Optional: Type the value that will be assigned to the column when no value is specified in an insert or load operation. The value must be a valid value for the column's data type.
If you are altering a table, this field is unavailable because you cannot change the default of an existing column.
Specifies that DB2 always generates values for the column when a row is inserted into the table. Available only for the ROWID data type.
You cannot update these column values. Always is recommended unless you specified Data capture on the Table page, and are using this table for replication.
If you are altering a table, this field is unavailable because you cannot change this attribute of an existing column.
Specifies that DB2 will generate a value for the column when a row is inserted into the table unless a value is specified in the insertion operation. Available only for the ROWID data type.
DB2 uses the specified value only if it is a valid ROWID value. The ROWID column must have a unique, single-column index. By default is recommended if you are using this table for replication.
If you are altering a table, this field is unavailable because you cannot change this attribute of an existing column.
Specify the schema of the distinct type (user-defined data type).
If you are altering a table, this field is unavailable because you cannot change the distinct type base of an existing column.
Specify the name of the distinct type to use for this column. The encoding scheme of the distinct type must be the same as the encoding scheme of the table. The subtype, if any, for the distinct type, is the subtype with which the distinct type was created.
If you are altering a table, this field is unavailable because you cannot change the distinct type base of an existing column.
Specifies that the column can contain null values.
If you want to use the column in a primary or unique key, it cannot be nullable.
If you are altering a table, this field is unavailable because you cannot change this attribute of an existing column.
Specifies that a default value is assigned to the column in the absence of a value specified in an insert or load operation. Do not specify for a ROWID column.
If you are altering a table, this field is unavailable because you cannot change the default of an existing column.
Specifies that a cast function with the same name as the distinct type name and schema specified in Distinct type name and Distinct type schema is used for the default value. You must have the EXECUTE privilege on the cast function.
If you are altering a table, this field is unavailable because you cannot change the default of an existing column.
Select the type of default value to be assigned to the column (or used in the cast function) when no value is specified in an insert or load operation. Available only if Default is selected.
You cannot specify a default value for the column if you specified a field procedure for the column.
If you are altering a table, this field is unavailable because you cannot change the default of an existing column.
Type the value that will be assigned to the column (or used in the cast function) in the absence of a value specified in an insert or load operation. The value must be a valid value for the column's data type.
If you are altering a table, this field is unavailable because you cannot change the default of an existing column.
Specifies that DB2 always generates values for the column when a row is inserted into the table. Use only if the distinct type is based on the ROWID data type.
You cannot update these column values. Always is recommended unless you specified Data capture on the Table page, and are using this table for replication.
If you are altering a table, this field is unavailable because you cannot change this attribute of an existing column.
Specifies that DB2 will generate a value for the column when a row is inserted into the table unless a value is specified in the insertion operation. Use only if the distinct type is based on the ROWID data type.
DB2 uses the specified value only if it is a valid ROWID value. The ROWID column must have a unique, single-column index. By default is recommended if you are using this table for replication.
If you are altering a table, this field is unavailable because you cannot change this attribute of an existing column.