Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.

     in_test CHAR(5)

     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


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020