Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Feb 2004 @ 15:12:37 GMT


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


Subj:   Query results in 3610 Error...
 
From:   Coffing Christopher

A-Team

Need some assistance on a 3610 error that we are getting when submitting a query to Teradata using security views that we created.

We are using the "USER" keyword to determine the session user trying to access the various views so we can limit the data returned...

The error occurs when we have multiple left outer joins and Right outer joins (we are using Business Objects (BOBJ))

BOBJ creates these nasty SQL statements that have combinations of both Left and Right outer joins.

We need to resolve this issue and rumor has it that we are not the first to get this error. Can anyone shed some light on this subject and is there a fix or a workaround that we can use?

Thanks for Brain Power...


Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master



     
  <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