3 error in disk_striping default, 4 data manipulation (dml) – Sybase ADAPTIVE SERVER IQ 12.4.0 User Manual
Page 28
Error in DISK_STRIPING default
Adaptive Server IQ 12.4.0
28
Release Bulletin for Digital UNIX
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.3 STRIP 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