Hi,
I am using the Host Integration Server DB2 Adapter to insert into 2 tables. Each table has it's own XML schema defined and two seperate insert statements are sent. I am getting the following errors when I attempt the inserts.
Table 1 Insert - "<tablename> ?<schema name> ?3 in *N not valid for operation. SQLSTATE: 55019 SQLCODE: -7008
(where <tablename> and <schema name> contain the actual values for the insert.)
Table 2 Insert - The parameter value for parameter 1 could not be converted to a native data type.
I've done some research on the problem and I haven't found a solution. Can someone guide me in the right direction on how to go about solving the problem. Is there some type of logging I can turn on from HIS or Biztalk to see the Insert statements being sent?
Thanks