Adding parameters to a stored procedure

Use the Add Parameter window to add parameters to a stored procedure.

To add a parameter:

  1. Specify a name for the parameter in the Parameter name field. The name can be a 1-8 character string.
  2. Select a type from the Parameter type list:
    3. INT DOUBLE PRECISION CHARACTER
    INTEGER DEC VARCHAR
    SMALLINT DECIMAL GRAPHIC
    REAL CHAR VARGRAPHIC
    FLOAT
  3. To specify parameter characteristics:
    1. Type values in the required fields:
      2. Length
      If you select CHAR, CHARACTER, VARCHAR, GRAPHIC, or VARGRAPHIC, then this field is available.
      Precision
      If you select DEC or DECIMAL, then this field is available.
      Scale
      If you select DEC or DECIMAL, then this field is available.
    2. If you select DEC or DECIMAL, specify a data type:
  4. To specify how applications use the parameter, select one of the radio buttons under IN/OUT:
    5. OUT IN/OUT
  5. Click OK.