Forum Replies Created
-
AuthorPosts
-
March 26, 2010 at 8:27 AM in reply to: Sybase ASE 12 Stored Procedure / ODBC Adapter / BizTalk 2009 / Windows Server 2008 #24467
Output Schema
<?xml version=”1.0″ encoding=”utf-16″?>
<xs:schema xmlns:msdata=”urn:schemas-microsoft-com:xml-msdata” xmlns=”” targetNamespace=”http://test/test” id=”testSchema” xmlns:xs=”http://www.w3.org/2001/XMLSchema”>
<xs:annotation>
<xs:appinfo>
<msbtsodbc:SQLCMD xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″>dbo.p_TEST_BIZTALK_SELECT_JB</msbtsodbc:SQLCMD>
<msbtsodbc:ODBCCMD xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″>{? =CALL dbo.p_TEST_BIZTALK_SELECT_JB}</msbtsodbc:ODBCCMD>
<msbtsodbc:ResponseRootName xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″>test</msbtsodbc:ResponseRootName>
<msbtsodbc:ResponseNS xmlns:msbtsodbc=”http://schemas.microsoft.com/BizTalk/2003″>http://test</msbtsodbc:ResponseNS>
</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>
March 26, 2010 at 8:25 AM in reply to: Sybase ASE 12 Stored Procedure / ODBC Adapter / BizTalk 2009 / Windows Server 2008 #24466Stored 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″ attributeFormDefault=”unqualified” elementFormDefault=”qualified” targetNamespace=”http://test/ODBCQUERY” xmlns:xs=”http://www.w3.org/2001/XMLSchema”>
<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>
</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>
<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>
Send it to me at [email protected]
To be more specific, what I need is to save a copy of each message that is received into the system onto the hard drive. I would also like to save a copy of sent messages on the disk
Thanks
Roger
March 25, 2010 at 1:36 PM in reply to: Expose over 100 DB2 Stored Procedures as WCF WebServices. #24461Hi all,
I came across this article about IBM Data Web Services, and wasn’t sure if it would be relevant for your scenario, but I thought I would throw that out here just in case…
http://www.databasejournal.com/features/db2/article.php/3784896
Daniel.
Hi Mike,
I would suggest you go through the EDI Interface Developer Tutorial on MSDN:
http://msdn.microsoft.com/en-us/library/bb226541(BTS.20).aspx
EDI in itself is a beast to learn, never mind using it in conjunction with BizTalk. This tutorial should give you a general idea and knowledge on how to do things and apply them to your particular scenario.
Daniel.
Hello I have the same problem, could you post an example
March 25, 2010 at 11:33 AM in reply to: Expose over 100 DB2 Stored Procedures as WCF WebServices. #24458Neal,
Did you ever find a managable solution for wrapping a large number of DB2 stored procedures? I’m very interested since I have a similar challenge.
Thanks! This solution worked for me.
Thank you for your answer, i will study more about the Messagebox database and extracting the dehydrated orchestration and get back with what we come up with.
Hi NISHIL,
After I added a new physical send port and ran the orchestration, it’s still stopped by the same error w/o producing the xml file. It’s still looking for a stored procedure named Table1. So I got in the monitoring and copied the message body out of the send adapter where the error took place.
<?xml version=”1.0″?><DB2arsif2Req xmlns=”http://DB2arsif2″><Table1 T7WDG4=”1100315″ T7WDG5=”130400″ T7WAHI=”1″ T7WDG7=”163403″ T7WDG9=”0″ T6WBP7=”1100314″ T7WDG8=”0″ T7WDG6=”1100323″ T7WBNW=”183012″ T7ACTN=”I” /><Table1 T7WDG4=”1100315″ T7WDG5=”130400″ T7WAHI=”1″ T7WDG7=”163403″ T7WDG9=”0″ T6WBP7=”1100314″ T7WDG8=”0″ T7WDG6=”1100323″ T7WBNW=”183012″ T7ACTN=”I” /></DB2arsif2Req>
Looks like what I said, it simply ignored the mapping and threw the data with source schema into the send adapter.
Is it possible that you could provide your email address for me to send u the project file and u take a look?
Regards, Steve
There is no way to move a running orchestration instance between BizTalk groups.
While this is not impossible, there is no code to support it. So you would have to write it all from scratch. Accessing the Messagebox database and extracting the dehydrated orchestration and copy to another MessageBox. This would only work for dehydrated orchestration, as active orchestrations are loaded in memory on one of the Biztalk Servers in the group (not even sure if you can identify which server is running it). The issues with dependencies would stop anyone from doing this.
Hi NISHIL,
Got it. I’ll post that for your diagnosis once I got that thing produced. Thank you.
Regards, Steve
Yes Steve,
First I want to have a look at the Output and then comment if you need the pipeline component or not.
Hi NISHIL,
Do you mean that I should follow the article that you provided to produce a file-output xml file and post it here, then you’d know how to build the custom pipline for adding the ns0 by looking at the output file?
Thanks, Steve
-
AuthorPosts