Archives of the TeradataForum
Message Posted: Thu, 19 Jun 2003 @ 18:15:03 GMT
| Subj: || || Re: Locking and Dead Lock Issue |
| From: || || Pradeep |
No I have not qualified this explicit lock for write command. If I try this then there will be always table lock no row level lock. This
will add wait time in another users execution time.
We are using set auto commit false before calling Stored Procedure. I don't have any idea how long the lock will be there on table, is it
till SQL got executed or I do explicit commit or till I set auto commit true.