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

Page 8

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

Image 8

Contents Release Bulletin Adaptive Server IQ For Digital Unix Product summaryRequired Operating System Patches Required Operating System Patches Adaptive Server IQRelease Bulletin for Digital Unix RestrictionsAdaptive Server IQ Converting 12.0.x databases to Following outer join format is supported Documentation for this version Installation Instructions Setting the Ldlibrarypath Environment Variable Accessing Current Release Bulletin Information Special migration instructionsObtaining query plans Go to support.sybase.comChanged functionality in this version Changed functionality in Adaptive Server IQImproved stored procedure output Adaptive Server IQ Known problems Adaptive Server IQ Stopasiq utilityTemporary tables in procedures Data definitionAdaptive Server IQ Queries 1 ANY, SOME, and ALL subquery supportAdaptive Server IQ Operations Large in subqueriesOutput to file in Dbisql Changing length of Dbisql column valuesUser-defined variable issue Dbspawn Error when starting a serverUnsupported terminal types cause Dbisql error User-defined variable issue Adaptive Server IQProblems with Add User-defined Data Type wizard DSE not installed on Windows client systemsAdd Service utility installed only with Server Components Notification message setting omitted from Index PropertiesDocumentation updates and clarifications Product compatibilitiesStartup, shutdown, and connection Data Type column in Table Editor retains focusAdditions to the startasiq or asiqsrv12 command-line options Specifying server switchesGm command line option Gn command-line optionUsing -v switch on 64-bit platforms Gm command line option Adaptive Server IQAdaptive Server IQ Confirming connections Using Odbc connectivity with UnixConfirming connections Stopasiq utility Using a .odbc.ini fileUsing a .odbc.ini file Adaptive Server IQ Addition to Stop Database statement Adaptive Server IQ Addition to Stop Database statementError in Dbstop example Configuration files do not accept quotesError in Dbstop example Adaptive Server IQ Disconnect details omittedSwitch must be uppercase Adaptive Server IQ Switch must be uppercaseData definition DDL Change to Create Database statementLowDisk functions as HighGroup Column Limit CorrectionJoint Virtual Table JVT definition IQ database file paths must be uniqueError documenting IQ Path Error in raw partition limitError on Create Dbspace Adaptive Server IQ Error documenting IQ PathSize clause of Create Dbspace Adaptive Server IQ Size clause of Create DbspaceAddition to Drop Database statement Adaptive Server IQ Recommended index types Changes to Using join indexesRecommended index types Changes to Using join indexes Adaptive Server IQ Id custid idlnameAdaptive Server IQ Changes to Using join indexes Error in Diskstriping default Data manipulation DMLAdaptive Server IQ Default Support for joins between stores or databasesNew and changed general database options New and changed general database options Adaptive Server IQAdaptive Server IQ Description InsertnumberrowsperrawiobufferCorrections to Insert Location Description Adaptive Server IQString function Repeat is supported Correction to Char functionNumber* function not supported Adaptive Server IQ String function Repeat is supportedBackup and system administration Using Isnull and CoalesceUsing Isnull and Coalesce Adaptive Server IQ New options for reserving spaceChange to error message Insufficient disk spaceForced recovery and leaked space recovery Effect of checkpoints Adaptive Server IQStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option Improved output in stored procedures New Stored Procedure ColumnsTransaction Log utility Minpasswordlength optionSpiqstatus now displays IQ Page Size Maintaining a transaction log or mirror Grant Connect for existing user ID Error message for buffer cache settingsSetting PrefetchBufferLimit option Documentation on Data Backup and Recovery Dropping users may delete tablesChanges to Backup statement Cleaning up after abnormal exitMonitoring server activity Using PC client applications Creating attribute tables for PowerBuilderClient applications Help filesTechnical Support Adaptive Server IQ plug-in help reflects Multiplex supportOther sources of information Sybase Certifications on the WebTechinfo.sybase.com