Archives of the TeradataForum

Message Posted: Sat, 20 Dec 2003 @ 16:34:57 GMT

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

Dheeraj,

The efficiency depends on your storage capacity and the no: of rows in your temp table ? Is this table been used in batch process again and again ?

If you have enough space I would suggest to DROP this temp table before you CREATE .

.SET the ERRORLEVEL for ERRORCODE 3807 (Table doesn't exist) some number like 2 or 4 to treat this as warning message

DROP TABLE ....; don't put any quit commands , if exists it will DROP, if not it will set the error level to the number you specified in SET

CREAT TABLE ...;

Hope this helps

Thanks,

Srini

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