Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 23:44:40 GMT


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


Subj:   Business Objects SQL Parsing
 
From:   Mark Buckley

We utilize Business Objects against Teradata and we often modify the SQL generated by Business Objects.

The problem is that BO sends the SQL to Teradata to parse and adds a false condition where 1=0. Oracle recognizes this false condition and does not try and execute the SQL but just runs it through the parsing engine. Teradata actually runs the query which can result in a long delay if it is a large query.

Has anyone come across this and found a way of getting either Business Objects to parse it locally or get teradata to parse it without running it?

Teradata has confirmed that this is the way Teradata works and it would require a significant change to their parsing engine.



     
  <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: 27 Dec 2016