Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Apr 2005 @ 18:42:01 GMT


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


Subj:   Re: Outer Join Syntax
 
From:   Jason.Fortenberry

Bill,

I have seen that in Cognos when we try to apply a "filter" to outer joined objects. The tables may be related in the tool via an outer join, but then Cognos would translate "filters" applied at runtime as only a WHERE clause and not an additional ON clause, as in your Desired SQL. I don't know if Cognos ever agreed it was a bug, but we assigned it as such, and created a work around by either never applying "filters" to outer joined objects or, most likely, by creating views in the DB that masked the outer join from the reporting tool. Cognos would then only look at this view and no longer have to generate outer join SQL.

For us, it had nothing to do with Teradata, its ODBC driver, CLI, or anything on the DB side. It was simply the way Cognos interpreted filters and generated SQL. I have not encountered that with any of the tools you mentioned, so I can't say if this is applicable to your situation :-(


Good luck,

Jason



     
  <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