>>-setenv--DEFAULT_ATTACH--1-----------------------------------><
The DEFAULT_ATTACH environment variable supports the legacy behavior of Version 7.x of Dynamic Server, which required that only nonfragmented B-tree indexes on nonfragmented tables can be attached.
If DEFAULT_ATTACH is set to 1, then all other indexes that you create, including R-trees and UDR functional indexes, must be detached, unless you specify the IN TABLE keywords as the Storage clause of the CREATE INDEX statement. (An attached index is one that has the same distribution scheme as the table on which it is built. Any index that does not is a detached index.)
If DEFAULT_ATTACH is not set, then any CREATE INDEX statement that does not specify IN TABLE as its Storage clause creates detached indexes by default. This release of Dynamic Server can support attached indexes that were created by Version 7.x of Dynamic Server.