Create Function panel

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.