DB2 Commit Statement

[Steve]

I am having trouble performing a COMMIT to my linked DB2
server. I use:

Select * from openquery(DB2, 'COMMIT') and i get this:

The OLE DB indicates that the object "MSDASQL" has no
columns.

Unable to Process object since the object has no
columnsProviderName

Any help would be appreciated.

[Axel Richter]

Steve schrieb:

Hi Steve,

you can ignore the error, since the "COMMIT" runs into DB2.

You may also switch your driver to AutoCommit-Mode, so you may avoid the
explicit commit (depends on your driver and the things you have to do).

Another issue is the problem, that SQL-Server creates a new connection
for the driver and sends the commit over this newly allocated
connection. So it may commit a transaction, which is not the one you
want to commit.

Axel.