Archives of the TeradataForum

Message Posted: Fri, 19 Sep 2014 @ 12:29:59 GMT

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

Hi Glenn,

I don't think this is how SQL Assistant works.

Suppose we are deploying below 10 views.

     Replace view viewname1 as locking for access Select ; Replace view viewname2
     as locking for access Select ; ..
     ..
     Replace view viewname10 as locking for access Select ;

If in this group View5 is error, SQL Assistant is not showing any error, instead it is deploying all 10 views, if we execute all 10 statements together.

But it is throwing error if we are deploying one by one.

In some days we are facing this issue. Some days its fine.

Regards,

Sughesh.

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