I am supporting a Lotus Notes/Web application that has been running without problems on Notes 5 for over a year. Recently, I upgraded my client to Notes 6.0.2 CF1 and part of the application failed when invoking an agent.
The agent communicates to DB2. The execute of the query works. The field lookups work. The fetch fails with “SQL0303N: A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH state.”
I started to play around with what DB2 fields were actually being requested on the query. I found the one field, which was defined to DB2 as LONGVAR, that seemed to be at the heart of the problem. Removing this field allowed the fetch to complete successfully. Note, DB2 fields that are defined as CHAR and VARCHAR do work.
I reverified with someone on Notes 5 that the code works there and it does. The lookup results for the LONGVAR field is the same on Notes 5 and 6.
Any help/ideas would be appreciated.