Archives of the TeradataForum
Message Posted: Thu, 12 Feb 2004 @ 15:12:37 GMT
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|