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.

Related tasks