Archives of the TeradataForum

Message Posted: Tue, 22 Mar 2005 @ 17:28:03 GMT

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

<-- Anonymously Posted: Tuesday, March 22, 2005 12:06 -->

Is there any way to include an EXPLAIN command in a macro? I've tried something like:

     CREATE MACRO prodm.m_test_explain AS
     (
             explain SELECT * from prodbov.av_sales_rep;
     );

But it throws an error 3706: Syntax error: expected something between '(' and the 'explain' keyword.

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