Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Jun 2010 @ 14:23:34 GMT


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


Subj:   Re: Setting Stored Procedure Exit Status ??
 
From:   Mohommod.Khan

You can still code in SQL the logic you want to be executed and based on the result you can take some action. You can also cause an intentional error if you think it should stop say 1/0 will raise an error. Similar logics can be added to raise different error level and you can store them onto a table and at the same time you can proceed/continue or abort. Also remember outside SP in execution level you can take all kind of actions. Say you are invoking this using Bteq and thus your controlling steps are much robust. You can use .GOTO or .IF then etc.


Hope this helps.

Thanks



     
  <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