Create Distinct Type panel
You use the Create Distinct Type panel to create a new distinct type.
Panel and field definitions
Process Options Utilities Help
FM/Db2 (DFG2) Create Distinct Type
Distinct Type:
Schema . . . . . . . . . . . + (optional)
Name . . . . . . . . . . . . +
Source Data Type:
Source Type . . . . . . . . +
Length/Precision . . . . . . (optional)
Scale . . . . . . . . . . . (optional)
For Data Encoding Method
1. SBCS 1. EBCDIC
2. Mixed 2. ASCII
3. Bit 3. UNICODE
Command ===>
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
- 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.