Use this stored procedure to prune a decision tree model.
Authorization
The privileges held by the authorization ID of the statement must include the IDAX_USER role.
Additionally, you must be the owner of the model or have the authority to alter it.
Syntax
IDAX.PRUNE_DECTREE(in parameter_string varchar(32672))
Parameter descriptions
- parameter_string
- Mandatory one-string parameter that contains pairs of
<parameter>=<value> entries that are separated by a comma.
- Data type: VARCHAR(32672)
- The following list shows the parameter values:
-
- model
- Mandatory.
- The name of the decision tree model that is to be pruned.
- Data type: VARCHAR(64)
- valtable
- Mandatory.
- The name of the input table.
- Data type: VARCHAR(128)
- id
- Optional.
- The column of the input table that identifies a unique instance ID.
- Default: The name of the id column that is used to build the model.
- Data type: VARCHAR(128)
- target
- Optional.
- The column of the input table that represents the class.
- Default: The name of the target column that is used to build the model.
- Data type: VARCHAR(128)
- qmeasure
- Optional.
- The quality measure for pruning.
- Allowed values are 'Acc' or 'wAcc'.
- Default: Acc
- Data type: VARCHAR(4)
- weights
- Optional.
- The input table that contains optional instance weights or class weights for the columns of the
input table.
- If this parameter is not specified, all weights have the value 1.
- Default: none
- Data type: VARCHAR(128)
Returned information
The number of the nodes of a pruned decision tree as a result set.
Example
CALL IDAX.PRUNE_DECTREE('model=adult_dectree, valtable=adult_prune');