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.
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.
If you are altering a table, this check box 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, or VARGRAPHIC is specified in the Data type field.
The maximum length varies depending on the data type. See the online help for details.
If you are altering a table, this field is unavailable because you cannot change the length of an existing 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 LONG VARCHAR data type):
If you are altering a table, this field is unavailable because you cannot change the subtype 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.
If you are altering a table, this check box is unavailable because you cannot change the default of an existing column.
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 Default is selected.
If you are altering a table, this field is unavailable because you cannot change the default type 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.
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 column's data type.
If you are altering a table, this field is unavailable because you cannot change the default value of an existing column.