DSXchange

Hi, We were able to get a hold of the DBA to disable the triggers. The DataStage job worked perfectly when the update triggers are inactive. In terms of # records I was only updating 5 records so I don't think it was a volume issue. I tried both a DS generated SQL and a user sql with the same results.

Hi,

Thanks for that. I am able to set the stage to Sequential now. However the same "Invalid Cursor State" still occurs, and no rows are updated in the target.

Could this be an issue with the driver?

Thanks for the reply. It doesn't look like the option is available. Please see below screenshot.

http://farm3.staticflickr.com/2847/1263 ... 6637_b.jpg

asorrell wrote: Can you try single-threading the ODBC Connector and see if that fixes the problem?.

Hi, I am having the same error while trying to update my target.
Is there a way to force single threading in ODBC Connector stage? I do not find this option in the tabs. We're running version 8.7 of DataStage.