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:
The IQ database can be either the local database or the remote database.
If an IQ table is to be used as a proxy table in ASE, the table name must be 30 characters or fewer.
In order to join a local Adaptive Server Enterprise table with a remote Sybase IQ 12 table, the ASE version must be 11.9.2 or higher, and you must use the correct server class:
To connect from a front end of Adaptive Server Enterprise 12.5 or higher to a remote Sybase IQ 12.5 or higher, use the ASIQ server class, which was added in ASE 12.5.
To connect from a front end of Adaptive Server Enterprise 11.9.2 through 12.0 to a remote Sybase IQ 12.x (or Adaptive Server Anywhere 6.x or higher), you must use server class ASAnywhere.
When you join a local IQ table with any remote table, the local IQ table must appear first in the FROM clause. This means that the local IQ table is the outermost table in the join.
Joins between Sybase IQ and Adaptive Server Enterprise rely on Component Integration Services (CIS).
For more information on queries from Adaptive Server Enterprise databases to Sybase IQ, see Component Integration Services Users's Guide in the Adaptive Server Enterprise core documentation set.
For more information on queries from Sybase IQ to other databases, see “Querying remote and heterogeneous databases.”
The CHAR data type is incompatible between Adaptive Server Anywhere and Sybase IQ when the database is built with BLANK PADDING OFF. If you want to perform cross-database joins between ASA and IQ tables using character data as the join key, use the CHAR data type with BLANK PADDING ON.
Sybase IQ CREATE DATABASE no longer supports BLANK PADDING OFF for new databases. This change has no effect on existing databases. You can test the state of existing databases using the BlankPadding database property:
select db_property ( ‘BlankPadding’ )
Sybase recommends that you change any existing columns affected by BLANK PADDING OFF, to ensure correct join results. Recreate join columns as CHAR data type, rather than VARCHAR. CHAR columns are always blank padded.