Data mining — Easy Mining optional parameters for the FindDeviations procedure

In addition to the basic parameters of the FindDeviations procedure, you can specify optional parameters. Optional parameters modify the default settings of the FindDeviations procedure. For example, you can use an optional parameter to specify a subset of columns for the input table to the FindDeviations procedure.

Removing fields from the input table

For example, to remove the column NBR_YEARS_CLI from the input table, you can use the following optional parameter string:

'DM_remDataSpecFld(''NBR_YEARS_CLI'')'

To remove more fields from the input table, you can use several DM_remDataSpecFld options in an Easy Mining procedure, or you can create a view that contains only the columns that you want to use and then specify this view as input for the Easy Mining procedure.

Example command with optional parameters

The following example shows the complete command to run the FindDeviations procedure including the optional parameter string:

db2 "call IDMMX.FindDeviations('BANK.DEV_CUSTOMERS',
                               'BANK.CUSTOMERS_MASTERDATA',
                               'DM_remDataSpecFld(''NBR_YEARS_CLI'')')"

For a listing of optional parameter strings, see Optional parameter strings.