Sybase IQ 12.4.0 installation instructions New and changed general database options

New and changed general database options Adaptive Server IQ 12.4.0

•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.6New 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)

30 Release Bulletin for Digital UNIX