Archives of the TeradataForum

Message Posted: Wed, 08 May 2013 @ 11:50:29 GMT

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

Put as follows:

     Diagnostic helpstats on for session;
     EXPLAIN
             < Your Insert statement>

1. Check if both tables exists first by doing count(*) from the tables

2. Check Datatypes of each tables and if they matches in the Insert and SELECT statements

Cheers

Sobhan

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