hello why if i am in a dataport (import), lock all the users that use the table that i am import, for example table nº 83 is very slow sql. help friends.
You set the transaction type (on SQL) for a dataport with the TransactionType property. The default value is “UpdateNoLock” which you can safely set to “Browse” or “SnapShot” if you’re exporting data. If you’re importing data I would suggest that you keep the default setting. Lars Strøm Valsted Head of Project and Analysis Columbus IT Partner A/S www.columbusitpartner.com Edited by - lstroem on 2001 Feb 28 14:02:26
and, why only a user can import data, other user is locked until the first finished. help, thanks