Archives of the TeradataForum

Message Posted: Thu, 12 Feb 2004 @ 18:33:02 GMT


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

Subj:		Volatile table existence check

From:		Anomy Anom

<-- Anonymously Posted: Thursday, February 12, 2004 13:19 -->

Can someone please help me here.

I would like to check if a volatile table that I am trying to create already exists. If not, I would want to create it, if it exists already, I do not want the script to fail. I know I can do error code trapping, but I would like to know if there is any way to avoid this error msg from appearing in the log.

So is there a way to do this in a bteq script.

Thanks!!!