I have heard people having this problem before so I would check
these things first
Also when you reply back can you tell us
Any info to help us. Also enable logging and look for any errors.
Allan Mitchell (Microsoft SQL Server MVP)
I support PASS - the definitive, global community for SQL Server
professionals - http://www.sqlpass.org
We are currently developing an MTS/ADO application that goes against a
DB2 database on OS/390 via a DB2 Connect gateway. We recently updated
our DB2 Run-time Client from V6 FP8 to V7 FP6. Ever since this
upgrade, we are now experiencing a CLI0109E error whenever we attempt
to insert a value into a CLOB column, or when we execute an UPDATE
that sets a LONG VARCHAR column to an empty string.
Can anyone out there shed some light on what might be going on here??
Is anyone out there doing anything similar to this?
We know this code works perfectly fine using a V6 Client going to DB2
for OS/390 V6 (We've know because we tested this on another DB2
subsystem here). The problem is that we had to go to the V7 client to
fix a different problem that we were having. That problem was fixed
by the V7 client but now it causes these INSERTs/UPDATEs to fail.
Any assistance/insight would be greatly appreciated. Thanks.
Perry R. Shindle