 |
 |
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.....
| |
