Sybase IQ 12.4.0 Server User Manual


 
Improved stored procedure output Adaptive Server IQ 12.4.0
8
Release Bulletin for Digital UNIX
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.2 Changed 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: