Parameter file

[dbomrrsm]

I am working with BO v6.5 on an Oracle 10g database.

The project requires that BO produces full outer join syntax i.e. left outer join , right outer join etc rather than just using the (+) on one side of the =.

I had a similar issue whilst working with SQL Server and this could be achieved by a change to the SQLSRVEN.PRM paramater file and a change in the universe parameters to use ANSI92. However, this was with BO version 5.

Does anone know where I can get hold of the correct parameter file for oracle that will make BO produce the full outer join syntax ?

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[rjcft001]

Within designer and with your universe open go to file-->properties and look at the parameter ANSI92, the help says the following :

Yes: Enables the SQL generation compliant to ANSI92 standard.

No: SQL generation behaves according to the PRM parameter OUTER_JOIN_GENERATION.

I would be interested in knowing if you can set full outer joins.

HTH