Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Aug 2013 @ 10:25:45 GMT


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


Subj:   Re: Macro vs Multi statement request in teradata
 
From:   Sughesh.Sumansingh

Hi Dipti,

Macro deals all statements inside as MSR. So when any one statement fails in between everything above will get rollback automatically.

Only difference is, in MSR you are using BT - ET (explicit). Macro is MSR implicitly.

Other difference is, in BT - ET you can have one DDL inside, when it is last one. but inside macro DDL statements are not allowed.

Hope it is clear to you.


Thanks,

Sughesh.



     
  <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: 23 Jun 2019