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

 

 

Stored Procedure

 

Create Procedure dbo.p_TEST_BIZTALK_SELECT_JB 

As

declare @amt_key int, @Datetime_column datetime

Begin

 

set rowcount 1

 

select @amt_key = amt_key

, @Datetime_column = Datetime_column 

from TEST_BIZTALK 

where isnull(char_column,”) != ‘Done’

 

set rowcount 0

 

begin transaction

 

update TEST_BIZTALK 

set char_column = ‘Done’

where amt_key = @amt_key 

 

select @amt_key

, @Datetime_column 

 

commit transaction    

 

end

 

Input Schema

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

<xs:schema xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003&#8243; attributeFormDefault=”unqualified” elementFormDefault=”qualified” targetNamespace=”http://test/ODBCQUERY&#8221; xmlns:xs=”http://www.w3.org/2001/XMLSchema”&gt;

<xs:annotation>

<xs:appinfo>

<msbtsodbc:SQLCMD>dbo.p_TEST_BIZTALK_SELECT_JB</msbtsodbc:SQLCMD>

<msbtsodbc:ODBCCMD>CALL dbo.p_TEST_BIZTALK_SELECT_JB</msbtsodbc:ODBCCMD>

<msbtsodbc:ResponseRootName>test</msbtsodbc:ResponseRootName>

<msbtsodbc:ResponseNS>http://test</msbtsodbc:ResponseNS&gt;

</xs:appinfo>

</xs:annotation>

<xs:element name=”ODBCQUERY”>

<xs:complexType>

<xs:sequence>

<xs:element minOccurs=”1″ maxOccurs=”unbounded” name=”QueryParameters”>

<xs:complexType>

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

<xs:annotation>

<xs:appinfo>

<msbtsdbc:ParamType xmlns:msbtsdbc=”http://schemas.microsoft.com/BizTalk/2003″>Int</msbtsdbc:ParamType&gt;

<msbtsodbc:ParamDir>ReturnValue</msbtsodbc:ParamDir>

<msbtsodbc:ParamSize>10</msbtsodbc:ParamSize>

</xs:appinfo>

</xs:annotation>

</xs:attribute>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>