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 | |
jdbc | Similar to | |
plus-equals | Oracle |
|
star-equals | Microsoft |
|
informix | Informix |
|
none | Use inner joins rather than outer joins. |