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
ZDT/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
Child panels
None.