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****


|