Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2003 @ 13:55:20 GMT


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


Subj:   Re: WITH clause not working
 
From:   David Wellman

My understanding is that the ODBC standard requiresthat each row in the answer set has the same format and structure, e.g. same number of columns and corresponding columns in each row have the same data type. Using the WITH clause obviously breaks this rule, hence it's not allowed. Bteq accepts it because Bteq is Teradata only.

The equivalent to WITH can be coded into an SQL statement and run via Queryman (oops, sorry - SQL Assistant) by using the ANSI style SUM syntax. You end up with the 'totals' figures added to every line of the output, but you do get the data.


Cheers,

Dave



     
  <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