Outer Joins

By default, the SQL repository uses outer joins in queries that involve auxiliary tables. Different database vendors use different syntax to create outer joins. The ATG platform automatically sets the outerJoinSupport property of the GSARepository component to specify the appropriate type of outer join to be used by the SQL repository. You can also configure this property manually, using the following values:

Value

Database Vendor

Description

sql92

Use FROM tablex x LEFT OUTER JOIN tabley y ON x.id = y.id

jdbc

Similar to sql92 but uses JDBC escape syntax {oj ... } to tell the JDBC driver to convert to native join syntax.

plus-equals

Oracle

x += y

star-equals

Microsoft
Sybase

x =* y

informix

Informix

FROM OUTER tablex

none

Use inner joins rather than outer joins.

 
loading table of contents...