Archives of the TeradataForum

Message Posted: Thu, 19 Oct 2006 @ 20:30:25 GMT

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

Michael,

Thanks for your reply,

Another script which is executing same time (with this script) creating secondary index on base table and dropping at end of the script.

I realized that, getting this error since both scripts are executing same time.

I have come up with solution that providing .SET RETRY ON that will resubmit the request again in the script.

But in the BTEQ .SET RETRY option is always ON (is that True stmt?) if it is true ,why it is not resubmitting the query again ?

I do not think providing "locking table for access" will help in this situation since table has 'EXCLUSIVE' locks.

.set errorlevel 2641 seviority 0; -- This makes script run successfully but may not get required data.

Any other alternative solution I might think of ?

Thanks,

Raju

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