Archives of the TeradataForum
Message Posted: Tue, 24 Oct 2006 @ 13:17:15 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|