Sybase IQ 12.4.0 installation instructions Improved stored procedure output Adaptive Server IQ

Improved stored procedure output	Adaptive Server IQ 12.4.0
• Improved stored procedure output	Stored procedures now display

output in units that are easier to understand.

•Minimum password length Database administrators can specify a minimum password length, to discourage easily discovered passwords.

For more information, see “MIN_PASSWORD_LENGTH option” on page 42

•ODBC 3.51 The ODBC driver has been updated to ODBC 3.51. This version of ODBC includes support for Unicode applications.

For more information, see “ODBC conformance” in the online edition of the Adaptive Server Anywhere Programming Interfaces Guide, Version 6.02.

• Control of allowed JOIN syntax In previous releases, some multi- table queries have been allowed that have ambiguous join clauses. In the present release, you can set an option to disallow such queries.

For more information, see “EXTENDED_JOIN_SYNTAX option” on page 28.

•Zero-length data storage If the length of a CHAR or VARCHAR cell is zero and the cell is not NULL, Adaptive Server IQ creates a zero-length cell, not a NULL. This change reverts to the original behavior in Adaptive Server IQ 12, as documented Chapter 5 of the Adaptive Server IQ Administration and Performance Guide.

6.2Changed functionality in Adaptive Server IQ 12.03.1

This section summarizes new features and other changes to Adaptive Server IQ added in Version 12.03.1 and not yet included in the documentation.

• sp_iqstatus displays IQ Page Size See “SP_IQSTATUS now displays IQ Page Size” on page 42 for more information.

•LOAD_MEMORY_MB option This option replaces several older options for adjusting memory use during loads. For more information see “LOAD_MEMORY_MB option” on page 30.

•JOIN_PREFERENCE option Two new values were added for the JOIN_PREFERENCE option. For more information see “JOIN_PREFERENCE Option” on page 31.

• Command-line options for server caching Two new server switches override the database cache parameters you set with the SET OPTION command:

8 Release Bulletin for Digital UNIX