3.1.4.2.2.1.3.18.1 Columns

The MDSCHEMA_INPUT_DATASOURCES rowset contains the following columns.

Name

Type

Restriction

Description

CATALOG_NAME

xsd:string

Yes

The name of the catalog.

SCHEMA_NAME

xsd:string

Yes

The name of the schema.<254>

DATASOURCE_NAME

xsd:string

Yes

The name of the data source object.

DATASOURCE_TYPE

xsd:string

Yes

The type of the data source. Valid values include the following:

  • Relational

  • Olap

CREATED_ON

xsd:dateTime

The date that the data source was created.

LAST_SCHEMA_UPDATE

xsd:dateTime

The date and time that the data source was last modified.

DESCRIPTION

xsd:string

The description of the action.

TIMEOUT

xsd:unsignedInt

The timeout of the data source in seconds.

DBMS_NAME

xsd:string

The external data source name.

DBMS_VERSION

xsd:string

The external data source version.

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="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="DATASOURCE_NAME" name="DATASOURCE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="DATASOURCE_TYPE" name="DATASOURCE_TYPE" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="CREATED_ON" name="CREATED_ON" type="xsd:dateTime" 
                        minOccurs="0" />
           <xsd:element sql:field="LAST_SCHEMA_UPDATE" name="LAST_SCHEMA_UPDATE" 
                        type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TIMEOUT" name="TIMEOUT" type="xsd:unsignedInt" 
                        minOccurs="0" />
           <xsd:element sql:field="DBMS_NAME" name="DBMS_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="DBMS_VERSION" name="DBMS_VERSION" type="xsd:string" 
                        minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>