Type a 1 to 18 character name for the column. Do not use the same name for more than one column of the table.
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.
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.
Optional: Type a 1 to 254 character (including embedded blanks) comment to document the column.
Specify the data type of the column.
Select to specify that the column can contain null values. Clear this check box if you do not want the column to be nullable.
If you want to use the column in a primary or unique key, it cannot be nullable.
Type the length (byte count) of the column. The default length is 1 character. Available only if CHAR, VARCHAR, GRAPHIC, or VARGRAPHIC is specified in the Data type field.
The maximum length varies depending on the data type. See the online help for details.
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.
Specify a subtype for a character string column (CHAR, VARCHAR, or LONG VARCHAR data type):
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.
Select to specify a default value to be assigned to the column when no value is specified in an INSERT or LOAD.
Select the type of default value to be assigned to the column when no value is specified in an INSERT or LOAD. Available only if the Default check box is selected.
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.
Type the value that will be assigned to the column when no value is specified in an INSERT or LOAD. Available if Constant value is specified for Default. The value must be a valid value for the columns data type.
Submits the data in the notebook and keeps the notebook open for further input. Available only when the required fields are completed.
Closes the window.