Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 25 Sep 2015 @ 12:58:06 GMT

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

Subj:   Re: Recursive query help
From:   Frydryszak, Marek

5000 parts of SQL ??? are you sure ???

I can't even imagine such long SQL - must have over 150 MB...

Can Teradata parse it ?

Theoretically it is possible to get rid of recursive query and develop table operator which will concatenate sqltextinfo into clob regardless of number of parts.

But it requires some experience in table operators.

  <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