Archives of the TeradataForum

Message Posted: Thu, 18 Sep 2003 @ 13:45:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Tony,

In teradata -- read locks block writers which is not the case in db2 and oracle ...ask your customer to create a view with access lock (ex : replace view db.viewname as locking db.tablename for access select * from db.tablename;) and let her go against the view instead of the base table...doing this way will not cause any locking issues with your nightly loads and she can still have the cognos impromptu scheduler logged on....Bharat

	<Prev	Next>		<<First	<Prev	Next>	Last>>