Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

162 Chapter 10
Technical Articles
IMAGE/SQL with TurboIMAGE/XL Enhancements
Key Features of B-Tree Indices
Following are key features of B-Tree indices:
1. B-Tree index can be created only on the key item of the master data
set.
2. B-Tree searches using the search items of all of its corresponding
detail paths can be done.
3. You may create B-Tree indices for zero, one, or more master data
sets.
4. DBSCHEMA has a new option, INDEXED, for the SET specification.
New syntax
NAME:setname,{M[ANUAL] | A[UTOMATIC]}[/INDEXED]
[(read class list)/(write class list)][,device class];
5. DBUTIL has new commands and options.
• New ADDINDEX, DROPINDEX, and REBUILDINDEX commands (to
be used for one, more than one, or all masters).
Syntax
{ADDI[NDEX] | DROPI[NDEX] | REBUILDI[NDEX]}
database name[/maintword] FOR {ALL | setnamelist | setnumlist}
Parameters
setnamelist is the list setname[,…]
setnumlist is the list setnum[,…]
ALL means all master data sets for the database.
• The SET command has a new BTREEMODE1 option to set DBFIND
mode 1 access ON or OFF for a B-Tree wildcard search for X and U
types. The default is OFF. The ON setting allows you to use B-Tree
indices for generic search without making application changes.
Also, it allows you to define your own database-wide wildcard
character.
New Syntax
SET database name[/maintword]
BTREEMODE1={ON | OFF}[,[WILDCARD=]c]
where c is any printable ASCII character, and the default
character is @.
• The SHOW command has a new INDEX, INDEXES, or INDICES
option.
New Syntax
SHOW database name[/maintword]
{INDEX | INDEXES| INDICES}