Error in DISK_STRIPING default

Adaptive Server IQ 12.4.0

9.3 Error in DISK_STRIPING default

The Adaptive Server IQ Reference contains an error in the General Database Options table in Chapter 5, “Database Options.” The DISK_STRIPING option default should be ON.

9.4 Data manipulation (DML)

9.4.1 DISK_STRIPING default

The Adaptive Server IQ Reference contains an error in the General Database Options table in Chapter 5, “Database Options.” The DISK_STRIPING option default is ON for Windows NT, and OFF for UNIX.

9.4.2 Correction to Introduction

The first item under “Adaptive Server IQ benefits” in Chapter 1, Introduction to Adaptive Server IQ, should read:

Intelligent query processing: Adaptive Server IQ uses index-only access plans to process only the data needed to satisfy any type of query

9.4.3STRIP load option clarification

The following clarification should be added to the Adaptive Server IQ

Administration and Performance Guide.

The STRIP load option does not apply to ASCII fixed-width inserts. For example, the STRIP option in the following statement is ignored:

load table dba.foo

(col1 ascii(3), col2 ascii(3)) from foo_data

quotes off escapes off strip off

9.4.4 EXTENDED_JOIN_SYNTAX option

 

This option is new in Version 12.4.0 and should be added to the Adaptive

 

Server IQ Reference Manual.

Function

Controls whether queries with an ambiguous syntax for multi-table joins are

 

allowed, or reported as an error.

Allowed values

ON, OFF

28

Release Bulletin for Digital UNIX

Page 28
Image 28
Sybase IQ 12.4.0 installation instructions Error in Diskstriping default, Data manipulation DML