Archives of the TeradataForum

Message Posted: Mon, 17 Jul 2006 @ 09:19:10 GMT

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

You could also check the &sysuvcnt[n] (where n=2-5, one each of the target table(s)). If it is greater than zero, you could rename the table after your END MLOAD and before your logoff command. This will be more automatic that calling BTEQ or any other utility.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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