Share via


SpecialFlag (clsColumn)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The SpecialFlag property assists the Distribution property in identifying the statistical nature of the column's data values for model optimization purposes.

Data Type

String

Access

Read/write for columns with a SubClassType of sbclsRegular whose IsKey and IsParentKey properties are False, read-only for all others.

Remarks

For columns whose IsKey or IsParentKey properties are set to True and columns with a SubClassType of sbclsNested, this property returns an empty string.

This property suggests the column contents to the mining model. This suggestion is used to optimize the mining model's MiningAlgorithm and can be left unspecified.

Supported values for this property are listed in the MINING_SERVICES schema rowset in the SUPPORTED_SPECIAL_FLAGS column.

Examples

Building a New Column

The following example builds a new column and sets its SpecialFlag property to PROBABILITY:

Set dsoColumn = dsoNestedCol.Columns.AddNew("pOn Sale")
dsoColumn.SourceColumn = "Sales.pOnSale"
dsoColumn.DataType = adDouble
dsoColumn.RelatedColumn = "On Sale"
dsoColumn.SpecialFlag = "PROBABILITY"