Changing parameters to a function

Use the Change Parameter window to modify parameters to an external function.

To change 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.