Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 18:24:54 GMT

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

If these views are for end user access, and if JK will allow me one slight recommended change, locking clause:

     REPLACE VIEW .
     (
             .
             column list
             .
     )
     AS
     LOCKING ROW FOR ACCESS
     SELECT
             .
             column_list
             .
     FROM
             .

Regards,

Dave

David W. Roth
Teradata Certified Master
TERADATA

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