Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Execution of multiple macro's inside a macro
 
From:   Amit Kumar Sinha

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016