Re: Sybase ASE 12 Stored Procedure / ODBC Adapter / BizTalk 2009 / Windows Server 2008

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Sybase ASE 12 Stored Procedure / ODBC Adapter / BizTalk 2009 / Windows Server 2008 › Re: Sybase ASE 12 Stored Procedure / ODBC Adapter / BizTalk 2009 / Windows Server 2008

March 26, 2010 at 8:27 AM #24467
community-content

    Output Schema

    <?xml version=”1.0″ encoding=”utf-16″?>

    <xs:schema xmlns:msdata=”urn:schemas-microsoft-com:xml-msdata” xmlns=”” targetNamespace=”http://test/test&#8221; id=”testSchema” xmlns:xs=”http://www.w3.org/2001/XMLSchema”&gt;

    <xs:annotation>

    <xs:appinfo>

    <msbtsodbc:SQLCMD xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″>dbo.p_TEST_BIZTALK_SELECT_JB</msbtsodbc:SQLCMD&gt;

    <msbtsodbc:ODBCCMD xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″&gt;{? =CALL dbo.p_TEST_BIZTALK_SELECT_JB}</msbtsodbc:ODBCCMD>

    <msbtsodbc:ResponseRootName xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″>test</msbtsodbc:ResponseRootName&gt;

    <msbtsodbc:ResponseNS xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″>http://test</msbtsodbc:ResponseNS&gt;

    </xs:appinfo>

    </xs:annotation>

    <xs:element msdata:IsDataSet=”true” msdata:UseCurrentLocale=”true” name=”test”>

    <xs:complexType>

    <xs:choice minOccurs=”0″ maxOccurs=”unbounded”>

    <xs:element name=”Table”>

    <xs:complexType>

    <xs:sequence>

    <xs:element minOccurs=”0″ name=”Column1″ type=”xs:int” />

    <xs:element minOccurs=”0″ name=”Column2″ type=”xs:dateTime” />

    </xs:sequence>

    </xs:complexType>

    </xs:element>

    <xs:element name=”OutParameters”>

    <xs:complexType>

    <xs:attribute name=”RETURN_VALUE” type=”xs:int” />

    </xs:complexType>

    </xs:element>

    </xs:choice>

    </xs:complexType>

    </xs:element>

    </xs:schema>