Defining properties when creating a distinct type

Use the Create Distinct Type window to define the properties for your distinct type.

Fields and controls

Authorities and privileges

To define distinct type properties:

1. Open the Create Distinct Type window.

2. Use the Type schema box to specify the schema for the distinct type that you're creating.

3. In the Type name field, enter a name for the distinct type that you're creating.

4. Use the Source data type box to specify the data type that your distinct type will use.

5. If you specified a data type of CHARACTER, VARCHAR, BLOB, CLOB, DBCLOB, GRAPHIC, or VARGRAPHIC, type the length (byte count) of the distinct type that you're creating in the Length field.

6. If you specified a data type of BLOB, CLOB, or DBCLOB, use the LOB unit box to specify a multiplier for the length of your distinct type.

7. If you specified a data type of DECIMAL:

   1. In the Precision field, type the precision (total number of digits) for the distinct type.

   2. In the Scale field, type the scale (number of digits to the right of the decimal) for the distinct type.

8. If you specified a data type of CHARACTER, VARCHAR, or LONG VARCHAR, select the Bit data check box to specify that the contents of the distinct type be treated as bit (binary) data.

9. Optional: In the Comment field, document the distinct type that you're creating.