Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Jan 2005 @ 12:09:54 GMT


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


Subj:   Questions about Packages & Stored Procedures
 
From:   cavenham

Hi,

I'm new to TeraData, and to this forum, so apologies if I am repeating earlier questions (perhaps you could point me to the appropriate thread?).

Does TeraData support Packages of related stored procedures? If so, does it also allow for package level constants and variables?

Is it possible to declare global (or session) level variables, or should I be thinking about storing values in a table and using SQL to retrieve the values at run time?

Can procedures be overloaded? If not, is there the concept of optional parameters; should I just supply null arguments instead?

Is there a way to group SQL statements so that they can be executed within a transaction that can be rolled back or committed depending on success/failure of each of the statements?


Thanks in advance.

Cavenham



     
  <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