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.

Related tasks