Adding parameters to a stored procedure

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

To add a parameter:

  1. In the Data Type list, select of the following radio buttons:
    2. Built-in
    Specifies a DB2 data type. If you select this radio button you must, specify built-in characteristics.
    Distinct
    Specifies a user-defined data type. If you select this radio button you must, specify distinct characteristics.
  2. Click OK.

Specifying built-in data type characteristics

  1. Specify a name for the parameter in the Parameter name field. The name can be a 1 to 8 character string.
  2. Select a type from the Parameter type list:
    3. INTEGER CHARACTER GRAPHIC
    SMALLINT VARCHAR VARGRAPHIC
    DECIMAL CLOB DATE
    REAL BLOB TIME
    DOUBLE DBCLOB TIMESTAMP
    ROWID
  3. To specify parameter characteristics:
    1. Type parameter characteristic values in the required fields:
      2. Length
      Precision
      Scale
    2. If you specify a character parameter, specify a data type:
      3. SBCS MIXED BIT
  4. To specify how applications use the parameter, select one of the radio buttons under IN/OUT:
      5. OUT IN/OUT
  5. If you specify a character parameter, specify a coded character set identifier (CCSID), either EBCDIC or ASCII.
  6. If you specify a large object parameter and a locator to a value instead of the actual value is passed as the input value, select the As locator check box.

Specifying distinct data type characteristics

  1. Specify a name for the parameter in the Parameter name field. The name can be a 1 to 8 character string.
  2. To specify how applications use the parameter, select one of the radio buttons under IN/OUT:
    3. IN OUT IN/OUT
  3. In the Distinct Type schema field, specify a schema. The specified schema is used as the first part of the two-part name.

    4. Tip: To display a list of existing objects, click on the (Browse) push button next to the field. Select an existing object from the list.

  4. In the Distinct Type name field, specify a long identifier for the type.

    5. Tip: To display a list of existing objects, click on the (Browse) push button next to the field. Select an existing object from the list.

  5. If a locator to a value is passed as the input value instead of the actual value, select the As locator check box.