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
Table lock
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
But, a faster solution may be to stage one or both output links to sequential files, then you can apply your inserts followed by your updates with reasonable transaction sizes.
Chuck Smith
www.anotheritco.com
www.anotheritco.com