 |
 |
Archives of the TeradataForum
Message Posted: Fri, 07 Oct 2011 @ 19:13:41 GMT
| Subj: | | Re: Stored Procedures - Cursor Processing |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, October 07, 2011 12:21 -->
Andy Baker wrote:
| | There is also a limited scalar SQL UDF functionality in 13.10 (supports expressions, functions, case - essentially what can be expressed as
an item in the column list of a Select) | |
Per one of the Teradata Developers I asked, the main restriction of scalar UDFs is that you are unable to do SQL. So if you need to do some
SQL within your procedure, then a scalar UDF would not work for this (i.e., splitting text strings). However, an external stored procedure may
(XSP).
To determine if a scalar UDF or an external stored procedure (XSP) would work better in splitting strings, more information is needed.
David, what version of Teradata Database are you on? Can you provide an example?
Thanks.
| |
