beautypg.com

3 error in disk_striping default, 4 data manipulation (dml) – Sybase ADAPTIVE SERVER IQ 12.4.0 User Manual

Page 28

background image

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