Mining data methods

The mining data methods act on a value of type DM_MiningData. The value includes information about the source data that you want to use to build a mining model.

With the mining data methods, you can create a value, specify the names of columns in the source data, and generate a logical data specification. You can also do other modifications to the DM_MiningData value and retrieve information about it.

Table 1. Methods for type DM_MiningData
Method Purpose SQL/MM method
DM_defMiningData method Defines a DM_MiningData value from a given source table name Y
DM_expMiningData method Exports the DM_MiningData value as a CLOB value N
DM_genDataSpec method Generates a value of type DM_LogicalDataSpec from a DM_MiningData value Y
DM_getColumnName method Returns the column name at a specified position.
Note: This method is deprecated. Use the table function DM_getFields instead.
N
DM_getFields(miningData) table function Returns a table of the fields contained in a value of type DM_MiningData.
Note: DM_getFields(miningData) is a table function.
N
DM_getFldAlias method Returns the alias name that corresponds to the specified column name.
Note: This method is deprecated. Use the table function DM_getFields instead.
N
DM_getNumColumns method Returns the number of columns specified in the DM_MiningData value.
Note: This method is deprecated. Use the table function DM_getFields instead.
N
DM_getTableName method Returns the name of the base table or view, or the nickname specified in a value of type DM_MiningData N
DM_getWhereClause method Returns a specified WHERE clause N
DM_impMiningData method Imports a previously exported DM_MiningData value N
DM_setColumns method Specifies the names of the columns in a source table by means of an XML string.
Note: This method is no longer required, because DM_defMiningData automatically sets column information.
N
DM_setFldAlias method Defines an alias name for a field contained in a DM_MiningData value Y
DM_setWhereClause method Sets a WHERE clause to filter the data N


Feedback | Information roadmap