MINING_SERVICE_PARAMETERS

MINING_SERVICE_PARAMETERS

This schema rowset provides a list of parameters that can be supplied when you are generating a mining model using the CREATE MINING MODEL statement. The client application will often restrict by SERVICE_NAME to obtain the parameters that are supported by the provider and are applicable to the type of mining model being generated.

Column name	Type indicator	Description
SERVICE_NAME	DBTYPE_WSTR	The name of the algorithm.
PARAMETER_NAME	DBTYPE_WSTR	The name of the parameter.
PARAMETER_TYPE	DBTYPE_WSTR	The OLE DB data type of the parameter.
IS_REQUIRED	DBTYPE_BOOL	TRUE if the parameter is required.
PARAMETER_FLAGS	DBTYPE_UI4	A bitmap that describes parameter characteristics. The following bit value constants are defined in Msmd.h for this bitmap: DM_PARAMETER_TRAINING (0x0000001) For training DM_PARAMETER_PREDICTION (0x00000002) For prediction
DESCRIPTION	DBTYPE_WSTR	Text that describes the purpose and format of the parameter.

Default Sort Order

SERVICE_NAME
PARAMETER_NAME

Restriction Columns

SERVICE_NAME
PARAMETER_NAME