This function reads a Demographic or Center-based Clustering model from a file, and returns it as data of type DM_ClusteringModel. This data can then be inserted into a table where one of the columns is designated for this data type.
The encoding of characters in the imported file is specified by a parameter.
Parameters
- input file name
- The name and the full path of the file to be imported. The specified
file must correspond to the following conditions:
- The file must exist on the database server.
- The DB2® instance owner (unfenced) or the DB2 fenced user (fenced) must have read access to the file.
- The file must be of one of the supported formats.
You can also use files that are compressed with gzip.
- encoding name
- Intelligent Miner® supports different encoding names. The MIME encoding strings are recommended, for example, iso-8859-1.
- If the encoding name is a non-empty string, the value is interpreted as an XML encoding. The content of the imported file is parsed according to this encoding. The imported file must be a PMML document.
- If the encoding name is the string 'SYSTEM', the locale settings of the operating system are used to determine the encoding of the file.
- If the encoding name is NULL, the encoding is determined by the
imported file.
- If the file is a PMML document, the standard rules of the XML specification apply. That is, the encoding is either specified explicitly or assumed to be Unicode by default.
- If the imported file is written in Intelligent Miner format, the locale settings of the operating system are used.
Return value
The return value is the imported model as data type DM_ClusteringModel.
If the input model is a Distribution-based Clustering model that does not contain distance units, they are calculated by default for numeric fields. The default value is half the square root of the variance of the field.
Usage
When the content of the file is read and imported into DB2, the file is no longer needed. However, you might want to keep the file in case you need to import the model again.