3.1.4.2.2.1.3.63.1 Columns
The MDSCHEMA_FUNCTIONS rowset contains the following columns.
Name |
Type |
Restriction |
Description |
---|---|---|---|
FUNCTION_NAME |
xsd:string |
No |
The name of the function. |
DESCRIPTION |
xsd:string |
No |
A description of the function. |
PARAMETER_LIST |
xsd:string |
No |
A description the parameters accepted by the function. |
RETURN_TYPE |
xsd:int |
No |
The OLE DB data type that is returned by the function. |
ORIGIN |
xsd:int |
Yes |
The possible values are as follows:
|
INTERFACE_NAME |
xsd:string |
Yes |
A logical classification of the type of function. For example:
|
LIBRARY_NAME<355> |
xsd:string |
Yes |
The library that implements the function. |
DLL_NAME |
xsd:string |
No |
Unused |
HELP_FILE |
xsd:string |
No |
Unused |
HELP_CONTEXT |
xsd:int |
No |
Unused |
OBJECT |
xsd:string |
No |
The type of object on which this function can be called. For example, the Children MDX function can be called on a Member object. |
CAPTION |
xsd:string |
No |
The caption of the function. |
PARAMETERINFO |
nested rowset |
No |
The parameters that can be provided to this function. |
DIRECTQUERY_PUSHABLE |
xsd:int |
No |
A bitmask that indicates the scenarios in which this function can be used when the model is in DirectQuery mode. The possible values are as follows:
|
The PARAMETERINFO column is a nested rowset. The following table describes the columns of that rowset.
Name |
Type |
Restriction |
Description |
---|---|---|---|
NAME |
xsd:string |
No |
The name of the parameter. |
DESCRIPTION |
xsd:string |
No |
The description of the parameter. |
OPTIONAL |
xsd:boolean |
No |
A Boolean that, when true, indicates that the parameter is optional. |
REPEATABLE |
xsd:boolean |
No |
A Boolean that, when true, indicates that multiple values can be specified for this parameter. |
REPEATGROUP |
xsd:int |
No |
The index of the repeat group of this parameter. |
The 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:complexType name="row"> <xsd:sequence> <xsd:element sql:field="FUNCTION_NAME" name="FUNCTION_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="PARAMETER_LIST" name="PARAMETER_LIST" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="RETURN_TYPE" name="RETURN_TYPE" type="xsd:int" minOccurs="0" /> <xsd:element sql:field="ORIGIN" name="ORIGIN" type="xsd:int" minOccurs="0" /> <xsd:element sql:field="INTERFACE_NAME" name="INTERFACE_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="LIBRARY_NAME" name="LIBRARY_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="DLL_NAME" name="DLL_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="HELP_FILE" name="HELP_FILE" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="HELP_CONTEXT" name="HELP_CONTEXT" type="xsd:int" minOccurs="0" /> <xsd:element sql:field="OBJECT" name="OBJECT" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="CAPTION" name="CAPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="PARAMETERINFO" name="PARAMETERINFO" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element sql:field="NAME" name="NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="OPTIONAL" name="OPTIONAL" type="xsd:boolean" minOccurs="0" /> <xsd:element sql:field="REPEATABLE" name="REPEATABLE" type="xsd:boolean" minOccurs="0" /> <xsd:element sql:field="REPEATGROUP" name="REPEATGROUP" type="xsd:int" minOccurs="0" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element sql:field="DIRECTQUERY_PUSHABLE" name="DIRECTQUERY_PUSHABLE" type="xsd:int" minOccurs="0" /> </xsd:sequence> </xsd:complexType>