Talk About Network

Google





Software > Biz Talk Application Integration > DB2 adapter upd...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 1215 of 1303
Post > Topic >>

DB2 adapter updategram transaction

by =?Utf-8?B?Tmtpc2hp?= <Nkishi@[EMAIL PROTECTED] > Feb 21, 2008 at 12:07 PM

Greetings,

Does anyone know how to affect multiple DB2 tables using an updategram, 
within a single unit of transaction?

I have been trying to insert data into multiple tables in one transaction.

To do so, I placed the various table data in the same <sync> block as
follows:

<sync>
	<after>
		<TABLE1 Fiels1="value" Field2="value">
		<TABLE2 Fiels3="value" Field4="value">
	</after>
</sync>

or :

<sync>
	<after>
		<TABLE1 Fiels1="value" Field2="value">
	</after>
	<after>
		<TABLE2 Fiels3="value" Field4="value">
	</after>
</sync>

But I am getting error messages that look like the following:

"A SQL error has occurred. Please consult the do***entation for your 
specific DB2 version for a description of the associated Native Error and
SQL 
State. SQLSTATE: 07006, SQLCODE: -301" (ie: "An input host variable cannot
be 
used, because of its data type.")

or

"The parameter value for parameter 7 could not be converted to the native 
data type"

I am using BizTalk 2006 (not R2), HIS 2006 and connecting on an AS400 v5r1

DB2.

Thanks for any help,

Nki****
 




 2 Posts in Topic:
DB2 adapter updategram transaction
=?Utf-8?B?Tmtpc2hp?= <  2008-02-21 12:07:00 
RE: DB2 adapter updategram transaction
=?Utf-8?B?QmhhcmF0IFNhaGF  2008-05-02 03:38:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Thu Jan 8 21:47:17 PST 2009.