Create Function: Returned Data Type panel

You use the Create Function: Returned Data Type panel to specify the data type returned by the function.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)        Create Function: Returned Data Type


 Returns:
    Schema   . . . . . . . . . .                   + (optional, for user-defined types)
    Data Type  . . . . . . . . .                                                     +
    Length/Precision . . . . . .          (optional)
    Scale  . . . . . . . . . . .          (optional)
    For Data                        Encoding Method
      1. SBCS                         1. EBCDIC
      2. Mixed                        2. ASCII
      3. Bit                          3. UNICODE

 Cast From:
    Data Type  . . . . . . . . .                                            + (optional)
    Length/Precision . . . . . .          (optional)
    Scale  . . . . . . . . . . .          (optional)
    For Data                        Encoding Method
      1. SBCS                         1. EBCDIC
      2. Mixed                        2. ASCII
      3. Bit                          3. UNICODE

 As Locator:
    Enter "/" to select option
       Return a locator to the value (LOB data type only)
 Command ===>                                                                 
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Schema
Specifies the schema name that qualifies a user-defined data type.
Data Type (Returns)
Specifies the data type returned by the function.
Length/Precision (Returns)
Specifies the length for built-in data types. For the decimal data type this is the precision.
Scale (Returns)
For the DECIMAL data type only.
For Data (Returns)
1.SBCS
Only for built in data types.
2.Mixed
Only for built in data types.
3.Bit
Only for built in data types.
Encoding Method (Returns)
Only for built-in data types. Specifies the actual data type returned by the function. See note below.
Data Type (Cast From)
Specifies the data type returned by the function.
Length/Precision (Cast From)
Specifies the length for built-in data types. For the decimal data type this is the precision.
Scale (Cast From)
For the DECIMAL data type only.
For Data (Cast From)
1.SBCS
Only for built in data types.
2.Mixed
Only for built in data types.
3.Bit
Only for built in data types.
Encoding Method (Cast From)
See note below.
As Locator
For LOB data types, specifies that a locator for the parameter is returned instead of the value itself.
Note: If Cast From is not specified, then the Returns Encoding Method defines the data type returned by the function to the invoking statement. If Cast From is specified, then the Cast From Encoding Method is the data type returned by the function and the Returns Encoding Method is the data type passed to the invoking statement by Db2® (having cast it from the Cast From data type).

Parent panels

Child panels

None.

Related tasks