Archives of the TeradataForum

Message Posted: Tue, 24 Oct 2006 @ 13:17:15 GMT

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

Hi All,

I want to find out when we have multiple macro's inside a macro then these macro's are processed parallel or sequentially? I went through the explain plan also but nowhere I got the hint that these macro's are processed in parallel.

Below is the sample SQL.

Any suggestions/tips to resolve this will be of great help.

     REPLACE MACRO LOAD_TEST_MACRO(
     in_test CHAR(5)
     )

     AS
     (
     EXEC  LOAD1(:in_test);
     EXEC  LOAD2(:in_test);
     EXEC  LOAD3(:in_test);
     EXEC  LOAD4(:in_test);
     EXEC  LOAD5(:in_test);
     EXEC  LOAD6(:in_test);
     );

Thanks & Regards

Amit

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