Archives of the TeradataForum

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

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

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>>