Archives of the TeradataForum

Message Posted: Fri, 26 Sep 2003 @ 18:02:15 GMT

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

Put lock after create view portion and before the select.

for example:

CREATE VIEW somedb.someview (a,b,c)
AS LOCK somedb.sometable FOR ACCESS
SELECT a,b,c
FROM somedb.sometable ;

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