Archives of the TeradataForum

Message Posted: Thu, 15 May 2003 @ 13:40:34 GMT

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

Clay:

Since EXPLAIN is an SQL modifier, it must appear at the beginning of an SQL statement. Otherwise, using a derived table would be an option.

Certainly one way to accomplish this is to export the output of the EXPLAIN to a text file. Then, you can import it and use an INSERT to put it into any table you want as a VARCHAR data type. The export and import operations can be accomplished using BTEQ or QUERYMAN. Either way, it is a two step operation (EXPLAIN then INSERT).

Regards,

Mike

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