I'm working with MS SQL Server database by ODBC stage (it's unix)
And I can not perform transaction, for example:
Code: Select all
I insert 50 rows into a table with values from 50 to 100
I execute a DS job that inserts 100 rows with value 1-100
What I was expecting is that the job will abort because of duplicate keys and a rollback will be done... so no change will be done for the table.
(I use transaction size 0 and array size 1000)
What I get is the first 50 rows inserted and the rest are rejected.
(as if the database has no transactions)
Any idea ?
How do I set SQL_AUTOCOMMIT ?
TNX,
Amos