Outer join Tick Box

building semantic layer
1

Not having much luck with joins at all.

Got a SQL Server 2000 database, set up a SQL Server 2000 ODBC connection using the SQL Server driver.

Why I try to create an outer join between 2 tables using a single field join the outer join tick box is greyed out.

I thought this only happened when using the generic ODBC driver.

The outer join lines in my sqlsrven.prm file has been changed to read
LEFT_OUTER=
RIGHT_OUTER=
OUTERJOINS_GENERATION=ANSI_92
because I was having problems with the syntax not being translated properly. (Still having that problem but I decided to start from scratch again).

Any help would be appreciated. The only help I’ve had from SQLServer gurus is to create views in the database that have the outer join as part of the creation script and select from the single view. Works for the moment but not practical for users creating their own reports.

Susan

suz_reid2 (BOB member since 2003-01-20)

2

From the SQLSrven.pdf file…

Ext_Join
Description Specifies whether or not outer joins are supported.
Possible Values YES Specifies that the database supports outer joins.
NO Specifies that the database does not support outer joins. The Outer join check
boxes in the Edit Join dialog box of DESIGNER are dimmed.
Comments You can find this parameter in all driver.prm files.
Example EXT_JOIN=YES

Any help?

Paul Williams :uk: (BOB member since 2002-07-10)

3

That solved that one.

Where can I get hold of the pdf file? I think this might be usful in the future.

Susan

suz_reid2 (BOB member since 2003-01-20)

4

It should get installed into \Online Guides<Language>.

Or just search for PDF files in the BO install directory and it should find them.

Paul Williams :uk: (BOB member since 2002-07-10)

5

Great, thanks

Susan

suz_reid2 (BOB member since 2003-01-20)

6

From memory, the other one you might want to set EXT_JOIN_INVERT too. I think Designer gets the symbol on the wrong end of the joins with SQLServer.

I can’t check at the moment, 'cos I don’t have any SQLServer connections.

Paul Williams :uk: (BOB member since 2002-07-10)