Archives of the TeradataForum
Message Posted: Fri, 19 Oct 2001 @ 12:01:26 GMT
| Subj: || || Re: Oracle - TeraData Equivalence Description |
| From: || || Cornelius Meade |
What Dieter is saying about BTEQ in comparison to SQL*Plus is all true...
SQL*Plus is not the same as PL SQL but Dieter does remind me of another difference that is worth noting in my view. Namely the current
state of STORED PROCEDURE support in Teradata which in my view is not entirely on par with what I have typically found in other RDBMS's.
This is not necessarily a bad thing, it is just that the capabilities/limitations are different enough that it can be difficult to convert
an Oracle SP into an equivalent TD construct. While there are generally several ways to approach a particular problem, if you use a lot of
stored procedures in Oracle, you will want to look closely at Teradata MACROs and STORED PROCEDURE capabilities to make sure you are not
facing some major revamping of your application logic.....