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
ZDT/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 Fromis not specified, then the
ReturnsEncoding Method defines the data type returned by the function to the invoking statement. If
Cast Fromis specified, then the
Cast FromEncoding Method is the data type returned by the function and the
ReturnsEncoding Method is the data type passed to the invoking statement by Db2® (having
castit from the
Cast Fromdata type).
Parent panels
Child panels
None.