Table lock
Posted: Wed Jul 27, 2005 2:32 pm
Hello Guys,
I created single Transform with 2 links one for update and another for Insert .like this
TX------>UPDATE
|
|
INSERT
I am updating and inserting SQL SERVER DATABASE.
while running the job it's locking the table.
I am getting following message:
LoadCustomerMasterPDROETest..Transformer_39.DSLink41: DSD.BCIClose call to SQLSetConnectOption(SQL.PRIVATE.TX) failed.
SQLSTATE=08S01, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Communication link failure
Thanks for help
Narasa
I created single Transform with 2 links one for update and another for Insert .like this
TX------>UPDATE
|
|
INSERT
I am updating and inserting SQL SERVER DATABASE.
while running the job it's locking the table.
I am getting following message:
LoadCustomerMasterPDROETest..Transformer_39.DSLink41: DSD.BCIClose call to SQLSetConnectOption(SQL.PRIVATE.TX) failed.
SQLSTATE=08S01, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Communication link failure
Thanks for help
Narasa