Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 04 Aug 2008 @ 06:12:22 GMT


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


Subj:   Re: Stored Procedure - compilation/execution mode
 
From:   sreenivasa.akula

Hi Sadashiv,

You Can Identify the Procedures which are in ANSI or TD Mode based on some specific commands like

"COMMIT AND ROLLBACK" Which are not present in TD mode

Its auto commit in TD Mode so no need to use..

So according to Anomy first get that procedure as "show procedure proc_name"

And check it for commit or rollback statements .



     
  <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: 15 Jun 2023