April 3, 2014 at 6:02 am
Hi, i have a stored procedure which uses the DB2OLEDB driver which i use to connect to an AS400 database. When the MSSQL job calls the Stored Proc i get an error
The requested operation cannot be performed because OLE DB Provider DB2OLEDB for linked server AS400 does not support the required transaction interface
but then i tried a part of my code inside the stored procedure which deletes records from the AS400 database, i placed it in the MSSQL Job and it is runs successfully.
could anyone explain to me why MSSQL job accepts the bare code instead of calling a stored procedure.
Thanks
April 3, 2014 at 7:20 am
jimbeam10 (4/3/2014)
Hi, i have a stored procedure which uses the DB2OLEDB driver which i use to connect to an AS400 database. When the MSSQL job calls the Stored Proc i get an errorThe requested operation cannot be performed because OLE DB Provider DB2OLEDB for linked server AS400 does not support the required transaction interface
but then i tried a part of my code inside the stored procedure which deletes records from the AS400 database, i placed it in the MSSQL Job and it is runs successfully.
could anyone explain to me why MSSQL job accepts the bare code instead of calling a stored procedure.
Thanks
Are there any explicit transactions involved here? Maybe the provider doesn't support it?
April 4, 2014 at 9:23 am
The other thing you may be running into is that the AS400 requires all tables accessed for anything but reading need to be journalled. If the table(s) you run only the delete portion of your procedure against are journalled, they would work, but any that aren't will generate an error.
Sorry, but I'm not sure if that is the error I received, but thought you should know about this gotcha anyway.
Don Urquhart
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply