BizTalk 2006 Host Adapters for IBM DB2

I am currently testing the DB2 Adapter going to an AS400. Our AS400 DB file
has a processed flag which we set to indicate various states. I can select
and get data into Biztalk using the following SQL command on the DB2
Transport Properties

select * from j.dld8cpp where D8WYS0 = 'Y'

My problem is when I attempt to use the "Update Command" portion of the DB2
Transport Properties. I select the Update Command, which gives me three
options
a) do nothing, b) delete after read or c)Update Command. I select the field
I wish to change after the read and this is what the tool generates:

UPDATE j.dld8cpp SET D8WYS0 = 'N' WHERE CURRENT OF <CURSOR>

Upon enabling the recieve location, the adapter throws an SQL update
exception and registers this error message in the Event Viewer:

Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5740
Date: 2/6/2007
Time: 3:43:28 PM
User: N/A
Computer: AITORDBIZTK02
Description:
The adapter "DB2" raised an error message. Details "Cursor SQLCURCS1?J.J for
table *N read-only. SQLSTATE: 42828, SQLCODE: -510".

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

On the SQL connection string I use my AS400 login which has full security
authority, I changed permissions on the DB file to allow public to do full
admin on it.

Anyone run across similar issues with the DB2 adapter?

****** On a side note if I try to go back into the DB2 Update Command area
and change the field I was trying to set. I get the followin error during
validation of the field:

Validation Error: The field D8WYS0 has a string value of "N" that is too
long. Please enter a string with a maximum length of 1.

The problem here is that D8WYS0 is defined on the AS400 as char(1) and the
adaptor picks this up as well.
.

Relevant Pages

  • Re: COBOL stored procedure for DB2
    ... Regarding how you precompile the app, you must specify target mfcob to db2 prep, rather than target ibmcob. ... Have you also confirmed that, prior to executing the CALL statement, the host variables specified within the client app have the appropriate values? ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: COBOL stored procedure for DB2
    ... Have you also confirmed that, prior to executing the CALL statement, the ... The DB2 CREATE PROCEDURE statement. ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: Trying to insert textboxdata into database
    ... typed with a @ prefix in SQL server in Access? ... also another remark a textbox is returning a string so why convert a string ... Dim Projname, ProjSpon As String ... 'Create SQL Select query command ...
    (microsoft.public.dotnet.languages.vb)
  • Re: OfficeCodeBehind?
    ... The WHERE clause needs to be inserted into the SQL string definition in this ... ' Set up the command text: ... I am not sure though whether that will work directly on an SQL Server ...
    (microsoft.public.word.vba.customization)
  • Re: Insert Command
    ... Change your SQL Insert stmt to: ... then add three parameters to your command, one for each of the actual ... quoted string, and you won't have to worry about SQL Injection attacks from ... programmer helping programmers. ...
    (microsoft.public.dotnet.languages.vb)