Archives of the TeradataForum
Message Posted: Fri, 21 Jan 2005 @ 12:09:54 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|