Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2001 @ 12:01:26 GMT

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

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

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