Create Procedure panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)                  Create Procedure


 Stored Procedure:
 Schema  . . .                   + (optional)
 Name  . . . .                                                     +
 Result Sets .          (optional)


 Stored Procedure Creation:
    Creation Options
       1. Parameters              (optional, usually required)
       2. Parameter Types         (optional, define parameters first)
       3. Option List             (required)
       4. Option List (More)      (optional)
       5. Create the Procedure

 Command ===>                                                                 
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel                              

Schema

The name of the schema in which the procedure is defined.

Name

The name of the stored procedure.

Result Sets

Specifies the maximum number of dynamic result sets that can be returned by the stored procedure.

Creation Options

Specify the number of the creation option you want to use:

1. Parameters

To specify information to define the parameters for a procedure to be created. Displays the Create Procedure: Parameters panel.

2. Parameter Types

To specify information to define the parameter types in relation to tables or views, and to specify the parameter type. Displays the Create Procedure: Parameter Types panel.

3. Option List

To specify information to define options for the procedure to be created. Displays the Create Procedure: Option List (1/2) panel.

4. Option List (More)

To further specify information to define options for the procedure to be created. Displays the Create Procedure: Option List (2/2) panel.

5. Create the Procedure

When you have finished specifying details for the stored procedure to be created, select this creation option to create the stored procedure.