Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 21 Apr 2011 @ 14:32:42 GMT

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

Subj:   Re: Recursive Queries and Stored Procedures
From:   Dieter Noeth

Simon Bloomer wrote:

  Exactly. We can write recursive queries and views, no problem, This is basic SQL. But you can't use them in a STORED PROCEDURE, which is something I stated in my original mail.  

Sorry, i was under the impression you could access a recursive view in an SP. This was a really stupid limitation in TD12.

  I was seeking advice an alternative way of achieving this so we can integrate it into SAP  

Recursion can usually be rewritten using some loops: WHILE/REPEAT and INSERTs into a Volatile Table within the SP.

Or maybe you might be able to rewrite the logic using OLAP functions.

What's the original query?


  <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