Adaptive Server IQ 12.4.0 | Default |
Default
Description
ON
This option reports a syntax error for those queries containing outer joins that have ambiguous syntax due to the presence of duplicate correlation names on a
The following join clause illustrates the kind of query that is reported.
( R left outer join T , T join S on ( C1 ) )
where C1 is a condition. If the option is set to ON, this query is interpreted as follows.
( R left outer join T on ( C1 ) ) join S on ( C2 )
where C1 and C2 are conditions.
9.4.5 Support for joins between stores or databases
This section clarifies current support for joins between stores or between databases.
Any joins within a given IQ database are supported. This means that you can join any system or user tables in the Catalog Store with any tables in the IQ Store, in any order.
Joins of IQ tables with tables in an Adaptive Server Enterprise database are supported under the following conditions:
•On UNIX platforms, the IQ database must be the remote database, and the Adaptive Server Enterprise database must be the local database. In other words, on ASE you must add the IQ server a remote server, and define the IQ tables as proxy tables.
•On Windows NT, the IQ database can be either the local database or the remote database.
Release Bulletin for Digital UNIX | 29 |
