Create Function panel
You use the Create Function panel to create a new function.
Panel and field definitions
Process Options Utilities Help
FM/Db2 (DFG2) Create Function
Function:
Schema . . . . . . + (optional)
Name . . . . . . . FUN1 +
Unique Name . . . . + (optional)
Function Creation:
Creation Options
5 1. Parameters (optional, usually required)
2. Parameter Types (optional, define parameters first)
3. Returned data type (required)
4. Option List (required)
5. Option List (More) (optional)
6. Create the Function
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.
- Unique Name
- Specifies a unique name for the function that is used by certain SQL statements and Db2® commands.
- Creation Options
- Specify the number of the creation option you want to use:
- 1. Parameters
- Displays the Create Function Parameters panel for defining parameters for the function.
- 2. Parameter Types
- Displays the Create Function Parameter Types panel for specifying additional type information for the function parameters.
- 3. Returned data type
- Displays the Create Function: Returned Data Type panel for specifying the data type returned by the function.
- 4. Option List
- Displays the Create Function Option List (1/2) panel for specifying various options for further defining the function.
- 5. Option List (More)
- Displays the Create Function Option List (2/2) panel for specifying additional options for the function.
- 6. Create the Function
- When you have finished specifying parameter, data type, and option information as required, select this creation option to create the function.
Parent panels
Child panels
To display this panel… | Use/do this |
---|---|
Create Function: Parameters panel | Creation option 1 |
Create Function: Parameter Types panel | Creation option 2 |
Create Function: Returned Data Type panel | Creation option 3 |
Create Function: Option List (1/2) panel | Creation option 4 |
Create Function: Option List (2/2) panel | Creation option 5 |