3.1.4.2.2.1.3.24.1 Columns

  • Article

The DMSCHEMA_MINING_MODEL_CONTENT_PMML rowset contains the following columns.

Name

Type

Restriction

Description

MODEL_CATALOG

xsd:string

Yes

The catalog name that is populated with the name of the database of which the model is a member.

MODEL_SCHEMA

xsd:string

Yes

The unqualified schema name.<275>

MODEL_NAME

xsd:string

Yes

The model name. This column cannot contain NULL.

MODEL_TYPE

xsd:string

Yes<276>

The model type. It is a server-specific string. It can be NULL.

MODEL_GUID

uuid

The GUID that identifies the model. Servers that do not use GUIDs to identify tables return NULL.

MODEL_PMML

xmlDocument

An XML representation of the model's content in PMML format.

SIZE

xsd:unsignedInt

The number of bytes in the XML string.

LOCATION

xsd:string

The location of the XML file. It is NULL if no location is available.

This rowset is not sorted.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:simpleType name="uuid">
         <xsd:restriction base="xsd:string">
           <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-
                               [0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
         </xsd:restriction>
       </xsd:simpleType>
       <xsd:complexType name="xmlDocument">
         <xsd:sequence>
           <xsd:any />
         </xsd:sequence>
       </xsd:complexType>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="MODEL_CATALOG" name="MODEL_CATALOG" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MODEL_SCHEMA" name="MODEL_SCHEMA" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MODEL_NAME" name="MODEL_NAME" type="xsd:string" />
           <xsd:element sql:field="MODEL_TYPE" name="MODEL_TYPE" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MODEL_GUID" name="MODEL_GUID" type="uuid" minOccurs="0" />
           <xsd:element sql:field="MODEL_PMML" name="MODEL_PMML" 
                            type="xmlDocument" minOccurs="0" />
           <xsd:element sql:field="SIZE" name="SIZE" type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="LOCATION" name="LOCATION" 
                            type="xsd:string" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>