Submits the data in the window and closes the window. Available only when the required fields are completed.
Displays the SQL statements that are generated by your choices in this window.
Cancels any unsaved changes that you made and closes this window.
Opens a window where you can browse for the item that you want to specify.
Optional: Specify an owner for this distinct type. If not specified, the DB2 subsystem user identifier for the current connection is used.
Type a 1- to 18-character name for this distinct type.
Select the DB2 built-in data type on which to base the distinct type that you are creating. A distinct type must be based on one of the built-in data types.
Type the length (byte count) of the distinct type. The default length is 1 character. Available only if CHARACTER, VARCHAR, GRAPHIC, VARGRAPHIC, CLOB, BLOB, or DBCLOB is specified in the Source 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 distinct type that has a DECIMAL source data type. The default precision is 5. Available only if DECIMAL is specified in the Source data type field.
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 distinct type with DECIMAL source type. The default scale is 0. Available only if DECIMAL is specified in the Source data type field.
Specify the unit of measurement for the Length. Available only if you specified a data type of CLOB, BLOB, or DBCLOB.
Specifies that this distinct type is used for single-byte data. Available only if CHARACTER, VARCHAR, or CLOB is specified in the Source data type field.
Specifies that this distinct type is used for mixed data. Available only if CHARACTER, VARCHAR, or CLOB is specified in the Source data type field.
Specifies that this distinct type is used for BIT data. Available only if CHARACTER or VARCHAR is specified in the Source data type field.
Specifies that this distinct type is used for data encoded using EBCDIC coded character sets. Available only if CHARACTER, VARCHAR, CLOB, GRAPHIC, VARGRAPHIC, or DBCLOB is specified in the Source data type field.
Specifies that this distinct type is used for data encoded using ASCII coded character sets. Available only if CHARACTER, VARCHAR, CLOB, GRAPHIC, VARGRAPHIC, or DBCLOB is specified in the Source data type field.
Optional: Type a 1- to 254-character (including embedded blanks) comment to document the distinct type.