Create Procedure: Option List (1/2) panel
You use the Create Procedure: Option List (1/2) panel to specify information to define options for the procedure to be created.
Panel and field definitions
Process Options Utilities Help
FM/Db2 (DFG2) Create Procedure Option List (1/2)
External Name . . . . . . . + (optional)
Package Collection . . . . + (optional)
Workload Manager Environment + (optional)
Time Limit (CPU units) . . . (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. PL/I 4. Contains SQL
Parameter Style
1. DB2SQL
2. General
3. General with nulls
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 procedure.
- Package Collection
- Specifies the package collection to be used when the procedure 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 procedure is to run.
- Time Limit (CPU units)
- Limit on processor service units used by a single invocation of the procedure.
- Language
- Application programming language of the procedure.
- SQL
- Specifies what type of SQL statements the procedure contains.
- Security
- Specifies the interaction of the procedure with an external security product.
- Parameter Style
-
- 1. DB2SQL
- Additional parameters containing Db2® information are passed to the procedure.
- 2. General
- Only the parameters on the call statement are passed to the procedure and they cannot be null.
- 3. General with nulls
- A vector of null indicators is passed in addition to the parameters on the call statement.
Parent panels
Child panels
None.