Create Distinct Type panel
You use the Create Distinct Type panel to create a new distinct type.
Panel and field definitions
- Schema
- The schema name in which to create the function.
- Name
- The name of the user-defined function.
- Source Type
- Db2® data type in which the distinct type is based.
- Length/Precision
- Data length of the distinct type. For distinct types based on the DECIMAL data type, this is the precision.
- Scale
- For distinct types based on the DECIMAL data type.
- For Data
- For non-DBCS data types (CHAR, VARCHAR and CLOB), specifies the subtype. BIT is not allowed for CLOB.
- Encoding Method
-
- 1. EBCDIC (default)
- Specifies the encoding scheme for the distinct data type.
- 2. ASCII
- Specifies the encoding scheme for the distinct data type.
- 3.UNICODE
- Specifies the encoding scheme for the distinct data type.
EBCDIC and ASCII specifies the encoding scheme for the distinct data type.
Parent panels
Child panels
None.