Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Oct 2011 @ 19:13:41 GMT

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

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?


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023