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