APT_RDBMS_COMMIT_ROWS
Posted: Tue Dec 18, 2007 4:10 pm
Hi,
I have parallel DS jobs that use ODBC stage to insert records to SQL server 2005 database and at the project level I have set APT_RDBMS_COMMIT_ROWS to 5000.
On the contratry to these settings, DBA confirmed that the commit is happening for every single row!!
Write Method = Upsert and I have a user defined SQL query to insert into the table.
Any ideas as to why there is a commit for every row. Am I missing some setting at DS level.
Thanks in advance
Sonia
I have parallel DS jobs that use ODBC stage to insert records to SQL server 2005 database and at the project level I have set APT_RDBMS_COMMIT_ROWS to 5000.
On the contratry to these settings, DBA confirmed that the commit is happening for every single row!!
Write Method = Upsert and I have a user defined SQL query to insert into the table.
Any ideas as to why there is a commit for every row. Am I missing some setting at DS level.
Thanks in advance
Sonia