Create Function: Option List (1/2) panel

You use the Create Function: Option List (1/2) panel to specify information to define options for the function to be created.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)         Create Function: Option List (1/2)

    External Name . . .                                + (usually optional)
    Scratchpad  . . . .                                  (optional)
    Package Collection                                 + (optional)
    WLM Environment . .                                + (optional)
    Time Limit  . . . .                                  (CPU units - optional)

    Language (Required)    SQL                       Security
       1. ASSEMBLE            1. Reads SQL Data         1. Db2
       2. C                   2. No SQL                 2. User
       3. COBOL               3. Modifies SQL Data      3. Definer
       4. PLI                 4. Contains SQL

    Parallelism
       1. Allowed
       2. Disallowed

    Run-time Options (optional)
                                                                               +
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

External Name: Name of the MVS™ load module that contains the user-written code to implement the function.
Scratch Pad: Size of the scratch pad allocated by Db2® and passed to the function when it is called.
Package Collection: Specifies the package collection to be used when the function is run. If not specified, the invoking program's package collection is used.
Workload Manager Environment: Specifies the MVS™ workload manager environment in which the function is to run.
Time Limit (CPU units): Limit on processor service units used by a single invocation of the function.
LANGUAGE (Required): Application programming language of the function:
SQL: Specifies what type of SQL statements the function contains:
Security: Specifies the interaction of the function with an external security product:
Parallel: Specifies if Db2® can consider parallelism for the function:
Run-time options: Specifies the Language Environment® run-time options to be used for the function.

Parent panels

Create Function panel

Child panels

None.

Related tasks

Creating a function