ODBC stage -Multiple update statements - Lock
Posted: Fri Jun 13, 2014 8:21 pm
Gurus,
Job flow
Row generator -----> transformer ------>ODBC stage
I have been trying to update a sybase table.There are multiple update statements.(I had used Row generator and transformer for a dummy purpose)Due to restrictions, we are allowed to use ODBC connector stage where we created DSN for sybase database. I had used all update statements inside a single ODBC stage and the job ran success with few(10) rows.
The actual update records will be in million.If I use full strength of records, is there any chance of getting the table lock error.If so ,how it can be avoided.
Your help most appreciated.
Note: The update statements are written for a same column in same table but with different where clauses.
Job flow
Row generator -----> transformer ------>ODBC stage
I have been trying to update a sybase table.There are multiple update statements.(I had used Row generator and transformer for a dummy purpose)Due to restrictions, we are allowed to use ODBC connector stage where we created DSN for sybase database. I had used all update statements inside a single ODBC stage and the job ran success with few(10) rows.
The actual update records will be in million.If I use full strength of records, is there any chance of getting the table lock error.If so ,how it can be avoided.
Your help most appreciated.
Note: The update statements are written for a same column in same table but with different where clauses.