Create Procedure: Parameter Types panel

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

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 ZDT/Db2 (DFG2)        Create Procedure: Parameter Types        Row 1 to 1 of 1

                                       As                                 IN
                    Data Type(Length)  LOC  <------Like Table/View------> OUT
 Parameter Name   +                 + (Y/N) Owner  + Name               + INOUT
 PARAM1             CHAR(3)                                                    
 ******************************* Bottom of data ********************************












 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Parameter Name
The name of the parameter.
Data Type(Length)
The data type of the parameter.
As LOC (Y/N)
For LOB data types, specifies that a locator for the parameter is passed instead of the value itself.
Owner
Defines the parameter as a locator to a transition table.
Like Table/View Name
The owner and name specify a table or view with columns that match those of the transition table.
IN OUT INOUT
Specifies whether the parameter can be used for input only, output only, or both input and output. Valid values are:
IN
Identifies the parameter as an input parameter.
OUT
Identifies the parameter as an output parameter.
INOUT
Identifies the parameter as both an input and output parameter.

Parent panels

Child panels

None.

Related tasks