Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 15 Mar 2002 @ 18:04:02 GMT

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

Subj:   Re: Stored Procedure Question about Cursors
From:   Eric J. Kohut


While I've never found this to be the case in almost 10 years working with Teradata, I'll have to take your word that the logic is too much for SQL.

I believe the answer to your questions is no, it is not doable in a Stored Procedure.

User Defined Functions are targeted for V2 R5.1 to provide this type of logic at the amp level through C code written by you to an API of amp operations / functions for access to standard parallel operations like sort, group, etc...

Stored Procedures really bring the application interface into the RDBMS and operate with a single session and one row at a time. I'd guess that the performance issue isn't the speed of the cursor but the speed of the update operation being executed one row at a time from a single session. The delay between each submission and response causes the entire serial process to appear slow.



Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

  <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: 28 Jun 2020