Sybase ADAPTIVE SERVER IQ 12.4.0 - Manual (Page 30)

New and changed general database options Adaptive Server IQ 12.4.0
30 Release Bulletin for Digital UNIX
• In order to join a local ASE table with a remote IQ 12 table, the ASE
version must be 11.9.2, and you must use the server class cd ASAnywhere.
Note Adaptive Server Enterprise 11.9.2 introduces new server classes to
be used for accessing remote databases from the ASE 11.9.2 system. You
must use server class ASAnywhere to access Adaptive Server IQ 12.0x or
Adaptive Server Anywhere 6.x from ASE 11.9.2. You use server class
ASIQ to access Adaptive Server IQ 11.5.1, 11.5.2, ... 11.5.x (that is, 11.5.1
or later as stated in New Functionality in Sybase Adaptive Server
Enterprise 11.9.2 is not correct for ASIQ 12).
• 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.
• The CHAR data type is incompatible between Adaptive Server Anywhere
and Adaptive Server IQ when the database is built with BLANK
PADDING OFF. If you want to perform cross-database joins between
ASA and ASIQ tables using character data as the join key, use the
VARCHAR data type or use CHAR with BLANK PADDING ON.
9.4.6 New and changed general database options
The following changes in general database options will be added to the next
update of the Adaptive Server IQ Administration and Performance Guide and
the Adaptive Server IQ Reference.
LOAD_MEMORY_MB option
This version includes a new option to simplify user control of heap memory
allocation during a load.
Function Specifies an upper bound on the amount of heap memory subsequent loads can
use.
Allowed Values 0 to 500
Default 0 (zero)